ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

23 / 68

Question 23:

You created a PL/SQL function with the RESULT_CACHE and RELIES_ON clauses. In which scenarios is the cached reuslt bypassed? (Choose all that apply) 

Answer options:

A. When the size for the memory allocated for the result cache is increased
B. When the function is executed in a session frequently with the same parameter value
C. When the database administrator has disabled the use of the result cache during application patching
D. Whe a data manipulation language statement in a session on a table or view that was specified in the RELIES_ON clause of a result-cached function