OCP-1Z0-053-200题-139题-205

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.