Which two statements are true?

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

Which two statements are true?

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

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 270MB 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 1

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