Which two statements are true about the query results stored in the query result cache? (Choosetwo.)
A.
If any of the tables used to build a query is modified by an ongoing transaction in the current session, the query result is not cached.
B.
A query result based on a read-consistent snapshot of data that is older than the latest committed version of the data is not cached.
C.
Adding the RESULT_CACHE hint to inline views enables optimizations between the outer query and the inline view, and the query result is cached.
D.
A query result for a query that has a bind variable is stored in the cache and is reused if the query is equivalent even when the bind variable has a different value.
http://docs.oracle.com/cd/E16655_01/server.121/e15857/tune_result_cache.htm#TGDBA642
“Adding the RESULT_CACHE hint to inline views disables optimizations between the outer query and inline view to maximize reusability of the cached result.”
http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm#i34608
Quotes from the above link:
“A query result based on a read-consistent snapshot of data that is older than the latest committed version of the data will not be cached.”
“If any of the tables used to build a cached result has been modified in an ongoing transaction in the current session then the result is never cached.”
A,B
http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm#i34608