Which two initialization parameters would you set to enable Automatic Shared Memory
Management? (Choose two.)
A.
set SHARED_POOL_SIZE to zero
B.
set STATISTICS_LEVEL to BASIC
C.
set SGA_TARGET to a non-zero value
D.
set DB_CACHE_SIZE to a non-zero value
E.
set STATISTICS_LEVEL to TYPICAL or ALL
Correct answer should be options C and E, refer oracle doc
https://docs.oracle.com/cd/B14117_01/server.101/b10752/memory.htm
setting shared pool size to zero will set its lowest limit, i.e. minimum value to zero.
agreed with Willgax
The official document would be
http://oracle.su/docs/11g/server.112/e10595/memory004.htm
go to where it says
The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function.
Answer A could also be correct. Here’s why
See …
http://oracle.su/docs/11g/server.112/e10595/memory004.htm#BGBFDFJB
look for the section that says
You can take advantage of automatic shared memory management by setting Total SGA Size to 992M in Oracle Enterprise Manager, or by issuing the following statements:
ALTER SYSTEM SET SGA_TARGET = 992M;
ALTER SYSTEM SET SHARED_POOL_SIZE = 0;
ALTER SYSTEM SET LARGE_POOL_SIZE = 0;
ALTER SYSTEM SET JAVA_POOL_SIZE = 0;
ALTER SYSTEM SET DB_CACHE_SIZE = 0;
ALTER SYSTEM SET STREAMS_POOL_SIZE = 0;
However as only 2 options are allowed I would say C and E.