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 4

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


ismaelv90

ismaelv90

I think A, D.

LDY

LDY

I think it’s AD