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.