Oracle Database 11g: Advanced PL/SQL — Question 4

Which two conditions must be true for a PL/SQL function to be result cached? (Choose two.)

Answer options

• A. It must be part of a package
• B. It must be a pipelined table function
• C. It must not be defined in an anonymous block
• D. It must have at least one OUT or IN OUT parameter

Correct answer: C, D

Explanation

For a PL/SQL function to be result cached, it must not be defined in an anonymous block (C) and should have at least one OUT or IN OUT parameter (D). Options A and B are incorrect because being part of a package and being a pipelined table function are not necessary conditions for result caching.