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 value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.
C.
The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to
zero.
D.
The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to
90 MB and 270 MB, respectively.
I think the answers are A and D
After restart database memory_max_target=memory_target
Ad when PGA_Aggregate_target and SGA_target both are set to values then
the initial values are 90 & 270 respectively.