WGU D330 DATA SYSTEMS
ADMINISTRATION TWO ACTUAL EXAM
PAPER 2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ What does ROWID include?1. Segment ID2. Data object number3. Relative
file number4. Block number in the file5. Row numberA) 1, 2, 3, 4B) 2, 3, 4,
5C) 1, 2, 4, 5D) 1, 3, 4, 5.
Answer: B) 2, 3, 4, 5
◍ Which two parameters configure automatic PGA memory management? 1.
SGA_TARGET 2. PGA_AGGREGATE_TARGET 3.
WORKAREA_SIZE_POLICY 4. PGA_AGGREGATE_LIMITA) 1, 2B) 1,
3C) 2, 3D) 2, 4.
Answer: C) 2, 3
◍ If neither spfileOCA12
C. ora nor spfile.ora files are found when starting the instance, which file
does Oracle look for?
A. initOCA12
C. ora
B. init.ora
C. None of the above
D. Both A and B.
Answer: A. initOCA12C.ora
◍ What is the primary responsibility of the System Monitor (SMON) process
in an Oracle database?
A. Performing instance recovery using the online redo log files
B. Writing the redo log buffer information to the online redo log files
, C. Executing user queries
D. Performing session cleanup.
Answer: A. Performing instance recovery using the online redo log files
◍ Can you start or stop a database using OEM Database Express?
A. Yes
B. No.
Answer: B. No
◍ You want to start up the database using a binary initialization file. What is
another name for this file?
A. Configfile
B. Pfile
C. Spfile
D. init_pfile.ora.
Answer: C. Spfile
◍ You would like to perform maintenance on the system and limit access to
only the DBA staff during the maintenance window. Which of the following
startup options should you use?
A. STARTUP NOMOUNT RESTRICT
B. STARTUP RESTRICT
C. STARTUP MOUNT RESTRICT
D. STARTUP MOUNT FORCE RESTRICT.
Answer: B. STARTUP RESTRICT
◍ Which of the following is true when upgrading a small Oracle database?A)
Performing a direct upgrade is always the best optionB) Exporting and
importing to an existing or newly created Oracle Database 12c database is
faster and cleanerC) Using Transportable Tablespaces is the most efficient
methodD) RMAN duplication is the recommended approach.
Answer: B) Exporting and importing to an existing or newly created Oracle
Database 12c database is faster and cleaner
◍ Which of the following statements has the correct syntax and gives the
ability to grant the privilege to other users?
, A. grant alter any table with grant option to desmond;
B. grant alter on gl.accounts to desmond with admin option;
C. grant alter any table to desmond with grant option;
D. grant alter any table to desmond with admin option;.
Answer: D. grant alter any table to desmond with admin option;
◍ Which of the following advisors determines if the space allocated to the
shared pool, large pool, or buffer cache is adequate?
A. SQL Tuning Advisor
B. SGA Tuning Advisor
C. Memory Advisor
D. Pool Advisor.
Answer: C. Memory Advisor
◍ What happens when either MEMORY_TARGET or
MEMORY_MAX_TARGET is specified and SGA_MAX_SIZE is not
specified?A) SGA_MAX_SIZE is set to the larger of MEMORY_TARGET
or MEMORY_MAX_TARGETB) SGA_MAX_SIZE is set to the smaller of
MEMORY_TARGET or MEMORY_MAX_TARGETC) SGA_MAX_SIZE
is set to the sum of MEMORY_TARGET and
MEMORY_MAX_TARGETD) SGA_MAX_SIZE remains unchanged.
Answer: A) SGA_MAX_SIZE is set to the larger of MEMORY_TARGET
or MEMORY_MAX_TARGET
◍ What happens when all members of a redo log-file group are lost except for
one?A) Database operation is affected, and data loss occurs.B) Database
operation is not affected, and no data loss occurs.C) Instance failure
occurs.D) An ARCn process is spawned..
Answer: B) Database operation is not affected, and no data loss occurs.
◍ If your database name is PROD and your instance name is PROD1, what
would be the name of the text-alert log file?
A. alertPRO
D. log
B. alert_PROD1.log
, C. PROD1alert.log
D. PROD_alert.log.
Answer: B. alert_PROD1.log
◍ A company needs to allow multiple computers to have access to a shared
printer. Which type of computer is required to manage the print requests to a
shared printer.
Answer: A server computer
◍ When a user session is terminated, which processes are responsible for
cleaning up and releasing locks?
A. DBWn
B. LGWR
C. MMON
D. PMON
E. SMON.
Answer: D. PMON
◍ Where is the trace backup created?A) In the $DIAGNOSTIC_DEST/trace
directory.B) In the
$DIAGNOSTIC_DEST/diag/<rdbms>/<database>/<instance>/trace
directory.C) In the $DIAGNOSTIC_DEST/backup directory.D) In the
$DIAGNOSTIC_DEST/data directory..
Answer: B) In the
$DIAGNOSTIC_DEST/diag/<rdbms>/<database>/<instance>/trace
directory.
◍ Which option provides the opportunity to defragment the database during
the upgrade?
A. Manual upgrade
B. DBUA upgrade
C. Data Pump Export/Import
D. Transport Database.
Answer: C. Data Pump Export/Import
◍ What process notifies the listener after a client connection is established in
ADMINISTRATION TWO ACTUAL EXAM
PAPER 2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ What does ROWID include?1. Segment ID2. Data object number3. Relative
file number4. Block number in the file5. Row numberA) 1, 2, 3, 4B) 2, 3, 4,
5C) 1, 2, 4, 5D) 1, 3, 4, 5.
Answer: B) 2, 3, 4, 5
◍ Which two parameters configure automatic PGA memory management? 1.
SGA_TARGET 2. PGA_AGGREGATE_TARGET 3.
WORKAREA_SIZE_POLICY 4. PGA_AGGREGATE_LIMITA) 1, 2B) 1,
3C) 2, 3D) 2, 4.
Answer: C) 2, 3
◍ If neither spfileOCA12
C. ora nor spfile.ora files are found when starting the instance, which file
does Oracle look for?
A. initOCA12
C. ora
B. init.ora
C. None of the above
D. Both A and B.
Answer: A. initOCA12C.ora
◍ What is the primary responsibility of the System Monitor (SMON) process
in an Oracle database?
A. Performing instance recovery using the online redo log files
B. Writing the redo log buffer information to the online redo log files
, C. Executing user queries
D. Performing session cleanup.
Answer: A. Performing instance recovery using the online redo log files
◍ Can you start or stop a database using OEM Database Express?
A. Yes
B. No.
Answer: B. No
◍ You want to start up the database using a binary initialization file. What is
another name for this file?
A. Configfile
B. Pfile
C. Spfile
D. init_pfile.ora.
Answer: C. Spfile
◍ You would like to perform maintenance on the system and limit access to
only the DBA staff during the maintenance window. Which of the following
startup options should you use?
A. STARTUP NOMOUNT RESTRICT
B. STARTUP RESTRICT
C. STARTUP MOUNT RESTRICT
D. STARTUP MOUNT FORCE RESTRICT.
Answer: B. STARTUP RESTRICT
◍ Which of the following is true when upgrading a small Oracle database?A)
Performing a direct upgrade is always the best optionB) Exporting and
importing to an existing or newly created Oracle Database 12c database is
faster and cleanerC) Using Transportable Tablespaces is the most efficient
methodD) RMAN duplication is the recommended approach.
Answer: B) Exporting and importing to an existing or newly created Oracle
Database 12c database is faster and cleaner
◍ Which of the following statements has the correct syntax and gives the
ability to grant the privilege to other users?
, A. grant alter any table with grant option to desmond;
B. grant alter on gl.accounts to desmond with admin option;
C. grant alter any table to desmond with grant option;
D. grant alter any table to desmond with admin option;.
Answer: D. grant alter any table to desmond with admin option;
◍ Which of the following advisors determines if the space allocated to the
shared pool, large pool, or buffer cache is adequate?
A. SQL Tuning Advisor
B. SGA Tuning Advisor
C. Memory Advisor
D. Pool Advisor.
Answer: C. Memory Advisor
◍ What happens when either MEMORY_TARGET or
MEMORY_MAX_TARGET is specified and SGA_MAX_SIZE is not
specified?A) SGA_MAX_SIZE is set to the larger of MEMORY_TARGET
or MEMORY_MAX_TARGETB) SGA_MAX_SIZE is set to the smaller of
MEMORY_TARGET or MEMORY_MAX_TARGETC) SGA_MAX_SIZE
is set to the sum of MEMORY_TARGET and
MEMORY_MAX_TARGETD) SGA_MAX_SIZE remains unchanged.
Answer: A) SGA_MAX_SIZE is set to the larger of MEMORY_TARGET
or MEMORY_MAX_TARGET
◍ What happens when all members of a redo log-file group are lost except for
one?A) Database operation is affected, and data loss occurs.B) Database
operation is not affected, and no data loss occurs.C) Instance failure
occurs.D) An ARCn process is spawned..
Answer: B) Database operation is not affected, and no data loss occurs.
◍ If your database name is PROD and your instance name is PROD1, what
would be the name of the text-alert log file?
A. alertPRO
D. log
B. alert_PROD1.log
, C. PROD1alert.log
D. PROD_alert.log.
Answer: B. alert_PROD1.log
◍ A company needs to allow multiple computers to have access to a shared
printer. Which type of computer is required to manage the print requests to a
shared printer.
Answer: A server computer
◍ When a user session is terminated, which processes are responsible for
cleaning up and releasing locks?
A. DBWn
B. LGWR
C. MMON
D. PMON
E. SMON.
Answer: D. PMON
◍ Where is the trace backup created?A) In the $DIAGNOSTIC_DEST/trace
directory.B) In the
$DIAGNOSTIC_DEST/diag/<rdbms>/<database>/<instance>/trace
directory.C) In the $DIAGNOSTIC_DEST/backup directory.D) In the
$DIAGNOSTIC_DEST/data directory..
Answer: B) In the
$DIAGNOSTIC_DEST/diag/<rdbms>/<database>/<instance>/trace
directory.
◍ Which option provides the opportunity to defragment the database during
the upgrade?
A. Manual upgrade
B. DBUA upgrade
C. Data Pump Export/Import
D. Transport Database.
Answer: C. Data Pump Export/Import
◍ What process notifies the listener after a client connection is established in
