Examine the settings for a user session given below : RESULT_CACHE_MODE =FORCE. What would be the implications of this setting on query execution?
Query results are bigger than the available space in the result cache are not cached
Query results are stored even when you explicitly use the /*+ no_result_cache */ hint in query.
All query results are stored in the result cache if possible.
Query results are stored only when you explicitly use the /*+ result_cache */ hint in your query