Which two statements are correct about the usage of parameters in functions? (Choose two.)
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Agree that correct answers are B,D.
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5009.htm
“In addition, when a function is called from within a query or DML statement, the function cannot:
Have OUT or IN OUT parameters”