Oracle
1Z0-146 · Question #17
Which two conditions must be true for a PL/SQL function to be result cached? (Choose two.)
The correct answer is C. It must not be defined in an anonymous block. D. It must have at least one OUT or IN OUT parameter. See the full explanation below for the reasoning.
Question
Which two conditions must be true for a PL/SQL function to be result cached? (Choose two.)
Options
- AIt must be part of a package.
- BIt must be a pipelined table function.
- CIt must not be defined in an anonymous block.
- DIt must have at least one OUT or IN OUT parameter.
How the community answered
(31 responses)- A10% (3)
- B19% (6)
- C71% (22)
Community Discussion
No community discussion yet for this question.