Oracle Database 12c: Advanced Administration — Question 109

You set the following parameters in the parameter file and restart the database instance:

NEMORY_MAX_TARGET=0 -

MEMORY__TARGET=500M -

PGA_AGGREGATE_TARGET=90M -

SGA_TARGET=270M -
Which two statements are true?

Answer options

• A. The memory_max_target parameter is automatically set to 500 MB.
• B. The pga_aggregate_target and sga_target parameters are automatically set to zero.
• C. The value of the memory_max_target parameter remains zero for the database instance.
• D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
• E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to

Correct answer: C, E

Explanation

The correct answer, C, is true because setting MEMORY_MAX_TARGET to 0 means it cannot exceed that value. E is also correct as the instance will not start with AMM enabled if the PGA and SGA parameters are defined, leading to a conflict. Options A, B, and D are incorrect as they misinterpret the effects of the parameter settings.