Which statement about the result is true?

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.