Following are the parameters and their values set in your database instance:

SGA_TARGET=8GB SGA_MAX_SIZE=10GB DB_KEEP_CACHE_SIZE=1GB You executed the following command to increase SGA_TARGET:

SQL> ALTER SYSTEM SET SGA_TARGET=9GB; Which three memory components would grow by the command above? (Choose three.)

Question

Following are the parameters and their values set in your database instance:

SGA_TARGET=8GB SGA_MAX_SIZE=10GB DB_KEEP_CACHE_SIZE=1GB You executed the following command to increase SGA_TARGET:

SQL> ALTER SYSTEM SET SGA_TARGET=9GB; Which three memory components would grow by the command above? (Choose three.)

Accepted Answer

A. large pool B. shared pool E. default pool of database buffer cache

Answer

C. multiple block size caches

Answer

D. keep pool of database buffer cache

Following are the parameters and their values set in your database instance: SGA_TARGET=8GB SGA_MAX_SIZE=10GB DB_KEEP_CACHE_SIZE=1GB You executed the following command to increase SGA_TARGET: SQL>…