Oracle
1Z0-146 · Question #62
1Z0-146 Question #62: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #62. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.