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
relies_on deprecated on 11.2?
In 11.2 the relies_on clause is deprecated, Oracle manages all data dependencies internally.
C, D
https://docs.oracle.com/database/121/TGDBA/tune_result_cache.htm#TGDBA618
http://www.oracle.com/technetwork/articles/sql/11g-caching-pooling-088320.html