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.



Leave a Reply 3

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


Peter

Peter

DE
In a text-based initialization parameter file, if you omit MEMORY_MAX_TARGET and include a value for MEMORY_TARGET, then the database automatically sets MEMORY_MAX_TARGET to the value of MEMORY_TARGET. If you omit the line for MEMORY_TARGET and include a value for MEMORY_MAX_TARGET, the MEMORY_TARGET parameter defaults to zero. After startup, you can then dynamically change MEMORY_TARGET to a nonzero value, provided that it does not exceed the value of MEMORY_MAX_TARGET.