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

Which two statements are correct about the usage of parameters in functions? (Choose two.)

Answer options

• A. Functions can have only in mode parameters.
• B. Functions called in SQL statements cannot have out or in out mode parameters.
• C. Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms
• D. Functions having in, out, or in out parameters can be called in PL/SQL procedures and anonymous blocks.

Correct answer: B, D

Explanation

Option B is correct because SQL statements do not support out or in out parameters in function calls. Option D is also correct as functions with any type of parameters can indeed be called in PL/SQL procedures and anonymous blocks. Options A and C are incorrect because functions can have parameters of all modes and are not limited to named PL/SQL subprograms.