Examine the parameter setting in your database:
Which statement is correct about the database?
A.
Automatic memory management is disabled because PGA_AGGREGATE_TARGET and
SGA_TARGET are not set
User process
B.
The instance is started but the database will not be opened until
PGA_AGGREGATE_TARGET and SGA_TARGET are set
Server process
C.
The database is opened but users cannot perform transactions until
PGA_AGGREGATE_TARGET and SGA_TARGET are set
System Monitor (SMON)
D.
Automatic memory management is enabled and, as per policy, 60% of the memory for
System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be
distributed at startup
QUESTION 480
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues
the following query:
SQL> SELECT * FROM sales;
Which process would retrieve the result from the database and return it to the client
program?
Process Monitor (PMON)
A.
Automatic memory management is disabled because PGA_AGGREGATE_TARGET and
SGA_TARGET are not set
User process
B.
The instance is started but the database will not be opened until
PGA_AGGREGATE_TARGET and SGA_TARGET are set
Server process
C.
The database is opened but users cannot perform transactions until
PGA_AGGREGATE_TARGET and SGA_TARGET are set
System Monitor (SMON)
D.
Automatic memory management is enabled and, as per policy, 60% of the memory for
System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be
distributed at startup
QUESTION 480
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues
the following query:
SQL> SELECT * FROM sales;
Which process would retrieve the result from the database and return it to the client
program?
Process Monitor (PMON)
E.
Checkpoint process (CKPT)
The answer here is wrong, the correct answer is D
MEMORY_TARGET is set, so PGA_AGGREGATE_TARGET and SGA_TARGET should be zero to allow automatic memory management. See:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory003.htm#ADMIN11199
The preceding steps instruct you to set SGA_TARGET and PGA_AGGREGATE_TARGET to zero so that the sizes of the SGA and instance PGA are tuned up and down as required, without restrictions. You can omit the statements that set these parameter values to zero and leave either or both of the values as positive numbers. In this case, the values act as minimum values for the sizes of the SGA or instance PGA.
A.
Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
B.
The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
C.
The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
D.
Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
Answer: D
true
correct