Oracle
1Z0-062 · Question #13
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 in
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
Managing the Database Instance
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
- DIt fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 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.
Topics
#SGA#ASMM#DB_CACHE_SIZE#Memory management