QUESTION 139
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 MemoryManagement is disabled.
D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or
SGA_TARGET parameter.
Answer: B
同205题:http://blog.csdn.net/rlhua/article/details/12499265
Explanation/Reference:
Section: Initialization, Parameters, File Location & Server Configuration
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 allocates60
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 defaultvalue 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.