Oracle
1Z0-146 · Question #147
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.)
The correct answer is 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. See the full explanation below for the reasoning.
Question
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.)
Options
- AAll query results are stored in the result cache if possible.
- BQuery results that are bigger than the available space in the result cache are not cached.
- CQuery results are stored only when you explicitly use the /*+ result_cache */ hint in your query.
- DQuery results are stored even when you explicitly use the /*+ no_result_cache */ hint in your query.
How the community answered
(56 responses)- A77% (43)
- C9% (5)
- D14% (8)
Community Discussion
No community discussion yet for this question.