Which two statements are true about the query results stored in the query result cache? (Choose
two.)
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.
A,B:
For a snapshot to be reusable, it must have read consistency. For a result set to be eligible for caching, at least one of the following conditions must be true:
– The read-consistent snapshot used to build the result must retrieve the most current, committed state of the data.
– The query points to an explicit point in time using flashback query.
If the current session has an active transaction referencing objects in a query, then the results from this query are not eligible for caching.
http://docs.oracle.com/database/121/TGDBA/tune_result_cache.htm#TGDBA630
C invalid:
Adding the RESULT_CACHE hint to inline views disables optimizations between the outer query and inline view to maximize reusability of the cached result.
D – invalid:
Cache results can be reused if they are parameterized with variable values when queries are equivalent and the parameter values are the same.
A , B