Oracle
1Z0-146 · Question #4
1Z0-146 Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
Question
The database instance was started up with the following initialization parameter values: MEMORY_TARGET = 500M RESULT_CACHE_MODE = FORCE RESULT_CACHE_MAX_SIZE = 0 After the database startup, to enable the result cache, you issued the following command: SQL> ALTER SYSTEM SET result_cache_max_size = 2M SCOPE = MEMORY; Which is the effect of this command?
Options
- AThe query result cache is enabled and 2 MB of the memory target is allocated to the result cache.
- BThe query result cache is enabled and 0.25% of the memory target is allocated to the result cache.
- CThe command produces an error because the database instance is started up with the
- DThe query result cache is not enabled because the database instance is started up with the
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.