Examine the settings for a user session given below:
RESULT_CACHE_MODE= FORCE
What would be the implications of this setting on query execution? (Choose all that apply.)
A.
All query results are stored in the result cache if possible.
B.
Query results that are bigger than the available space in the result cache are not cached.
C.
Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query.
D.
Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in your
query.
A,B
http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams207.htm#REFRN10270
docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm#i34548
A , B
A, B
A.
When set to FORCE, all results use the cache, if possible.
B.
Query results that are bigger than the available space in the result cache will not be cached.
http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm#i34548