Which statement is correct about the database?

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)