Oracle Database Advanced PL SQL 12c 1z0 148

Question : 22 of 54

Marks: +1, -0

You created a PL/SQL function with the RESULT_CACHE clause, which calculates a percentage of total marks for each student by querying the MARKS table.
Under which two circumstances will the cache for this function not be used and the function body be executed instead? (Choose two.)

When a user fixes incorrect marks for a student, with an update to the MARKS table, and then executes the function in the same session
When the amount of memory allocated for the result cache is increased
When the function is executed in a session frequently with the same parameter value
When the database administrator disables the result cache during ongoing application patching
When the maximum amount of server result cache memory that can be used for a single result is set to 0

Validate

Go to Question:

Prev Question

Next Question