OCP CBT Question 536

Please solve the following question.

You are administering an Oracle database. You notice that both SGA_TARGET and PGA_AGGREGATE_TARGET parameters are explicitly set. However, the MEMORY_TARGET parameter is also set to a non-zero value. Which memory management strategy is in effect?

sqlSHOW PARAMETER memory_target;SHOW PARAMETER sga_target;SHOW PARAMETER pga_aggregate_target;

Automatic Memory Management (AMM) is fully active and manages both SGA and PGA dynamically.

Automatic Shared Memory Management (ASMM) is active for SGA, and PGA is managed by PGA_AGGREGATE_TARGET, with MEMORY_TARGET acting as a ceiling.

MEMORY_TARGET is ignored because SGA_TARGET and PGA_AGGREGATE_TARGET are explicitly set.

The database will use manual memory management for both SGA and PGA.