Which two statements are true about the query results stored in the query result cache?

Which two statements are true about the query results stored in the query result cache? (Choose
two.)

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


morriarti

morriarti

“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.”