Oracle Database Advanced PL SQL 12c 1z0 148

© examsiri.com

Question : 9 of 54

Marks: +1, -0

Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?

The IN parameters must not include BLOB, CLOB, collection or record data types.
The function must be created with invoker’s rights or in an anonymous block.
The function must be declared as a pipelined table function.
The function must have an OUT or an IN OUT parameter.

Go to Question:

Prev Question

Next Question