Which two queries’ results cannot be cached? (Choose two.)
A.
queries having the GROUP BY clause
B.
queries having the ORDER BY clause
C.
the query on dictionary and temporary tables
D.
queries having SYSDATE and SYS_TIMESTAMP SQL functions
Which two queries’ results cannot be cached?
Which two queries’ results cannot be cached? (Choose two.)
C, D
https://docs.oracle.com/database/121/TGDBA/tune_result_cache.htm#TGDBA646
Help why C)?
D): psudo column could not be tracked so the result of query with pseudo column could not be cached.
C) is correct, but what’s the cause, if the result in SYSTEM OR TEMP table space could be tracked, why the result could not be cached?
CD
The result of a SQL query will not be cached if the SQL includes dictionary views, temporary tables, SYS-owned tables, sequences, pseudo columns (such as CURRVAL, NEXTVAL, SYSDATE, LEVEL, ROWNUM and so on), or non-deterministic PL/SQL functions.