Which two statements are true regarding these parameters after the database instance is restarted?

You set the following parameters in the parameter file and restarted the database:

MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true
regarding these parameters after the database instance is restarted? (Choose two.)

You set the following parameters in the parameter file and restarted the database:

MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true
regarding these parameters after the database instance is restarted? (Choose two.)

A.
The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

B.
The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are
set to 90 MB and 270 MB, respectively.

C.
The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed
manually.

D.
The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set
to zero.



Leave a Reply 0

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