which two situations is the body of a result-cached function executed?

In which two situations is the body of a result-cached function executed?
(Choose two.)

In which two situations is the body of a result-cached function executed?
(Choose two.)

A.
if the memory allocated for the result cache is increased

B.
if a session on this database instance invokes the function with the same parameter values

C.
if the first time a session on this database instance invokes the function with a parameter value

D.
if a session executes a data manipulation language (DML) statement on a table or view that was specified in the RELIES_ON clause of a result-cached function



Leave a Reply 3

Your email address will not be published. Required fields are marked *


wellingthon

wellingthon

relies_on deprecated on 11.2?

OldBoyOdeSu

OldBoyOdeSu

In 11.2 the relies_on clause is deprecated, Oracle manages all data dependencies internally.