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
https://docs.oracle.com/database/121/TGDBA/tune_result_cache.htm#TGDBA646
Answer A) B)
FORCE: The server strictly caches the results of all possible SQL
statements irrespective of the RESULT_CACHE hint specification in the
query. Besides the queries with caching limitations, only the queries
with the NO_RESULT_CACHE hint are ignored for caching. The caching
feature in the FORCE mode is known as automatic result cache.