Oracle Database Advanced PL SQL 12c 1z0 148

Question : 20 of 54

Marks: +1, -0

Examine this query executed as SYS and its output:

Which two observations are true based on the output? (Choose two.)

The client-side result cache and the server-side result cache are enabled.
All distinct query results are cached for the duration of a SYS user session.
Repetitive SQL queries and PL/SQL functions results are cached and automatically used from the cache across all SYS user sessions.
The result cache exists but which SQL queries are cached depends on the value of the RESULT_CACHE_MODE parameter.
Repetitive SQL queries executed on permanent non-dictionary objects may have faster response times.

Go to Question:

Prev Question

Next Question