Which parameter must be set to which value to implement automatic PGA memory
management?
A.
Set memory_target to zero.
B.
Set STATISTICS_LEVEL to BASIC.
C.
Set pga_aggregate_target to a nonzero value.
D.
Set pga_aggregate_target and sga_target to the same value.
E.
Set sgajtarget to zero.
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11233
A and C, if memory_target set to non-zero value then used AMM and pga_aggregate_target is lower limit for PGA.
I think you can select only one answer so from my opinion it would be C
C
http://docs.oracle.com/cd/B28359_01/server.111/b28318/memory.htm
When automatic memory management is not enabled, the default method for the instance PGA is automatic PGA memory management.
C
C