You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.
Which statement about the result is true?
A.
The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE.
B.
The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA.
C.
The database instance starts, but Automatic Memory Management is disabled.
D.
The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter.
Explanation:
The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA. In this scenario, you specified a value for the MEMORY_TARGET parameter, but not values for the SGA_TARGET and PGA_AGGREGATE_TARGET parameters. In such a scenario, Oracle automatically tunes memory, but does not use any default values. Instead, at startup, Oracle allocates 60 percent of memory to the SGA and 40 percent to the PGA. If you set MEMORY_TARGET and PGA_AGGREGATE_TARGET but not SGA_TARGET, SGA_TARGET is set to either the SGA_MAX_SIZE value or the value of MEMORY_TARGET – PGA_AGGREGATE_TARGET, whichever is smaller.
If you set MEMORY_TARGET and SGA_TARGET but not PGA_AGGREGATE_TARGET, PGA_AGGREGATE_TARGET is set to a value of MEMORY_TARGET – SGA_TARGET. The option that states the database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE is incorrect. Oracle does not set a default value for SGA_TARGET or PGA_AGGREGATE_TARGET in this scenario.
The option that states the database instance starts, but Automatic Memory Management is disabled is incorrect because you specified a value for the MEMORY_TARGET initialization parameter.
The option that states the database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter is incorrect. You can set only the MEMORY_TARGET parameter and leave the PGA_AGGREGATE_TARGET and SGA_TARGET parameters unset, and the database instance will start successfully.