Prev Question
Next Question

You set the following parameters in the parameter file and restart the database instance:
MEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true?

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
nonzero values.

Explanation:

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *