Multiple choice technology databases

Examine the settings for a user session given below : RESULT_CACHE_MODE =FORCE. What would be the implications of this setting on query execution?

  1. Query results are bigger than the available space in the result cache are not cached

  2. Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in query.

  3. All query results are stored in the result cache if possible.

  4. Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

RESULT_CACHE_MODE=FORCE forces all query results to be cached if possible, ignoring the /*+ no_result_cache */ hint. The FORCE setting means caching happens regardless of explicit hints. Results are cached when they fit in available cache space, but hints that disable caching are overridden.

Keep practicing — related questions