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? (Choose two.)
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
C,D.
http://docs.oracle.com/database/121/TGDBA/tune_result_cache.htm#TGDBA642
C , D