Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?
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.
A
Correct is A. In Reffrence link you may find:
To be result-cached, a function must meet all of these criteria:
– It is not defined in a module that has invoker’s rights or in an anonymous block.
– It is not a pipelined table function.
– It does not reference dictionary tables, temporary tables, sequences, or nondeterministic SQL functions.
– It has no OUT or IN OUT parameters.
– No IN parameter has one of these types:
BLOB
CLOB
NCLOB
REF CURSOR
Collection
Object
Record
-The return type is none of these:
BLOB
CLOB
NCLOB
REF CURSOR
Object
Record or PL/SQL collection that contains an unsupported return type