Oracle Database 11g: Program with PL/SQL — Question 63

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

Answer options

• A. A procedure can contain a return statement without a value.
• B. A function can return multiple values using a single return clause.
• C. A procedure can be executed as part of a SQL expression or as a PL/SQL statement.
• D. A function can contain zero or more parameters that are transferred from the calling environment.

Correct answer: A, D

Explanation

Option A is correct because a procedure can indeed include a return statement that does not return a value. Option D is also correct as functions can have zero or more parameters. Options B and C are incorrect; a function cannot return multiple values using a single return clause, and while a procedure can be executed in various contexts, it cannot be used in SQL expressions.