Which two statements are true?

You set the following parameters in the parameter file and restart the database instance:
Exhibit: Which two statements are true?

You set the following parameters in the parameter file and restart the database instance:
Exhibit: Which two statements are true?

A.
The pga_aggregate_target and sga_target parameters are automatically set to zero.

B.
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.

C.
The value of the memory_max_target parameter remains zero for the database instance.

D.
The memory_max_target parameter is automatically set to 500 MB.

E.
The lower limits of the pga_aggregate_target and sga_target parameters are set to 90
MB and 270 MB respectively.

Explanation:



Leave a Reply 2

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


Vlad

Vlad

ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET