Question 52:
Which two statements are true about the query results stored in the qeury result cache? (Choose two.)
Answer options:
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