Oracle
1Z0-146 · Question #72
You created a PL/SQL function with the RESULT_CACHE and RELIES_ON clauses. In which scenarios is the cached result bypassed? (Choose all that apply.)
The correct answer is C. when the database administrator has disabled the use of the result cache during application patching D. when a data manipulation language (DML) statement is executed in a session on a table or view that was. See the full explanation below for the reasoning.
Question
You created a PL/SQL function with the RESULT_CACHE and RELIES_ON clauses. In which scenarios is the cached result bypassed? (Choose all that apply.)
Options
- Awhen the size for the memory allocated for the result cache is increased
- Bwhen the function is executed in a session frequently with the same parameter value
- Cwhen the database administrator has disabled the use of the result cache during application patching
- Dwhen a data manipulation language (DML) statement is executed in a session on a table or view that was
How the community answered
(52 responses)- A8% (4)
- B21% (11)
- C71% (37)
Community Discussion
No community discussion yet for this question.