Oracle
1Z0-060 · Question #20
1Z0-060 Question #20: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-060 to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
Question
Examine the current value for the following parameters in your database instance: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issue the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; Which statement is true?
Options
- AIt fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
- BIt succeeds only if memory is available from the autotuned components if SGA.
- CIt fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
- DIt fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
Unlock 1Z0-060 to see the answer
You've previewed enough free 1Z0-060 questions. Unlock 1Z0-060 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.