Oracle Database: Program with PL/SQL — Question 5

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

Answer options

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

Correct answer: C

Explanation

The correct answer is C because only pipelined table functions can utilize RESULT_CACHE. Options A, B, and D are incorrect because they pertain to other requirements that do not specifically relate to the successful compilation of a function with RESULT_CACHE.