Which two statements are correct in this scenario?

Consider an Oracle instance that is using Automatic Shared Memory Management. You set
some of the System Global Area (SGA) parameters as shown below:
SGA_TARGET=200 MB
SHARED_POOL_SIZE=20 MB
DB_KEEP_CACHE_SIZE=30 MB
Which two statements are correct in this scenario? (Choose two.)

Consider an Oracle instance that is using Automatic Shared Memory Management. You set
some of the System Global Area (SGA) parameters as shown below:
SGA_TARGET=200 MB
SHARED_POOL_SIZE=20 MB
DB_KEEP_CACHE_SIZE=30 MB
Which two statements are correct in this scenario? (Choose two.)

A.
If SGA_TARGET is reduced to 150 MB,then it will not affect the value of the
DB_KEEP_CACHE_SIZE parameter.

B.
230 MB will be allocated among the auto-tuned SGA components.

C.
Shared pool size will never shrink below 20 MB.

D.
A maximum of 20 MB will be allocated to the shared pool.

E.
250 MB will be allocated among the auto-tuned SGA components.



Leave a Reply 0

Your email address will not be published. Required fields are marked *