Oracle
1Z0-146 · Question #62
The database instance was started up using the automatic memory management feature. No value was set for the RESULT_CACHE_MAX_SIZE parameter. Examine the following initialization parameter settings…
The correct answer is C. The query results are stored and 0.25% of the memory target is allocated to the result cache. See the full explanation below for the reasoning.
Question
The database instance was started up using the automatic memory management feature. No value was set for the RESULT_CACHE_MAX_SIZE parameter. Examine the following initialization parameter settings for your database:
MEMORY_TARGET = 500M RESULT_CACHE_MODE = MANUAL You execute a query by using the result_cache hint. Which statement is true in this scenario?
Options
- AThe query results are not stored because no memory is allocated for the result cache.
- BThe query results are stored and 0.5% of the memory target is allocated to the result cache.
- CThe query results are stored and 0.25% of the memory target is allocated to the result cache.
- DThe query results are not stored because the RESULT_CACHE_MODE parameter is not set to FORCE.
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C85% (22)
- D8% (2)
Community Discussion
No community discussion yet for this question.