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

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

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 DBMS_TRACE.trace_all_callsDBMS_TRACE.trace_all_calls

Leave a Reply 10

Vidvischi Andrei

Can anyone tell me why D is a correct answer ?

pradeepa

I think Answer D is wrong as I couldnt see any such conditon for using result cache in any document.I think Option A and C is right.

Durpdurp

QUESTION IS WRONG IN THIS PAGE!

Of course D doesn’t make sense. D is “function must have at least one OUT or IN OUT parameter”.

somnath sikdar

QUESTION IS WRONG IN THIS PAGE!

Option D doesn’t make sense. D should be “function must have at least one OUT or IN OUT parameter”.

Edgardo

– A is inexact so it’s wrong
– B is wrong, it’s the opposite,
– C is correct
– D is true by discharge but it doesn’t make sense

MeOrYou

D) Doesn’t make make sense!

Also suggestion about OUT or IN OUT parameter is wrong!

Restrictions on Result-Cached Functions

To be result-cached, a function must meet all of the following criteria:
(…)
It has no OUT or IN OUT parameters.
(…)

Mikhail

A,C

Leo Yu

C) is the only correct answer

Google

Here are some hyperlinks to websites that we link to due to the fact we think they may be really worth visiting.