Examine the current value for the following parameters in your database instance:SGA_MAX_SIZE = 1024M SGA_TARGET = 700MDB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200MYou 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?*The SGA_TARGET parameter can be dynamically increased up to the value specified for the SGA_MAX_SIZE parameter, and it can also be reduced.*Example:For example, suppose you have an environment with the following configuration:SGA_MAX_SIZE = 1024M SGA_TARGET = 512MDB_8K_CACHE_SIZE = 128MIn this example, the value of SGA_TARGET can be resized up to 1024M and can also be reduced until one or more of the automatically sized components reaches its minimum size. The exact value depends on environmental factors such as the number of CPUs on the system. However, the value of DB_8K_CACHE_SIZE remains fixed at all times at 128M*DB_8K_CACHE_SIZESize of cache for 8K buffers*For example, consider this configuration:SGA_TARGET = 512MDB_8K_CACHE_SIZE = 128MIn this example, increasing DB_8K_CACHE_SIZE by 16 M to 144M means that the 16M is taken away from the automatically sized components. Likewise, reducing DB_8K_CACHE_SIZE by 16M to 112M means that the 16M is given to the automatically sized components.
Question:
Which statement is true?
Options:
It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
It succeeds only if memory is available from the autotuned components if SGA.
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
Correct Answer
The Correct Answer for this Question is
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.