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
In 11gR2, the only required parameter for automatic memory management is memory_target. If SGA_TARGET or (PGA_AGGREGRATE_TARGET) is then set, the value act as minimum values for the sizes of the SGA or instance PGA.
People and Kevin,
The response is correct. Pre attention about question: Automatic Shared Memory Target and not Automatic Memory Traget.
So C and E are correct.