Which two statements are true?

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?

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?

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.



Leave a Reply 0

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