Oracle Database Administration 2022 Certified Professional — Question 40

SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_TARGET is then set to a nonzero value but MEMORY_MAX_TARGET is not set.
Which two statements are true? (Choose two.)

Answer options

• A. SGA_TARGET and PGA_AGGREGATE_TARGET will define lower size limits for the SGA and PGA, respectively.
• B. MEMORY_MAX_TARGET will default to either the sum of SGA_TARGET and PGA_AGGREGATE_TARGET or to MEMORY_TARGET, whichever is smaller.
• C. PGA_AGGREGATE_TARGET will be ignored but SGA_TARGET will define the lower size limit for SGA size.
• D. MEMORY_MAX_TARGET will default to zero.
• E. SGA_TARGET will be ignored but PGA_AGGREGATE_TARGET will define the lower size limit for PGA size.
• F. MEMORY_MAX_TARGET will default to either the sum of SGA_TARGET and PGA_AGGREGATE_TARGET or to MEMORY_TARGET, whichever is greater.
• G. MEMORY_MAX_TARGET will default to MEMORY_TARGET.

Correct answer: A, G

Explanation

The correct answer A states that SGA_TARGET and PGA_AGGREGATE_TARGET provide minimum size limits for their respective memory areas, which is true. Answer G is also correct because when MEMORY_MAX_TARGET is not set, it defaults to MEMORY_TARGET. The other options are incorrect as they either misrepresent the behavior of MEMORY_MAX_TARGET or the limits of SGA and PGA sizes.