ExamQuestions.com

Register
Login
Upgrade to Oracle Database 12c Exam Questions

Oracle

Upgrade to Oracle Database 12c

32 / 125

Question 32:

Examine the current values 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? 

Answer options:

A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
B. It succeeds only if memory is available from the autotuned components if SGA.C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.