UPDATED WGU D330 OBJECTIVE ASSESSMENT 2 EXAM
PREP VERIFIED QUESTIONS, ANSWERS & RATIONALES
(LATEST 2026 EDITION)
This comprehensive mock exam bank provides verified
questions, answers, and deep-dive rationales tailored
specifically for the Western Governors University D330 objective
assessment. It systematically covers core Oracle Database
Administration concepts including instance management,
SGA/PGA memory architecture, physical storage, network
configuration, and user security auditing. Mastering these high-
yield practice questions ensures a thorough understanding of
the exam material and provides an excellent path to passing on
your first attempt.
Part 1: Database Architecture & Instance Management
1. Which file must be accessible to transition an Oracle
database instance from the NOMOUNT state to the
MOUNT state?
A. Data file
B. Control file
C. Redo log file
D. Password file
Answer: B
Rationale: The control file contains the physical
structure of the database, including data file and redo
log locations. Moving from NOMOUNT (where only
, memory and background processes exist) to MOUNT
requires reading the control file specified in the
initialization parameter file. Data files and redo logs are
only opened during the transition from MOUNT to
OPEN.
2. During which stage of database startup is the server
parameter file (SPFILE) read?
A. MOUNT
B. OPEN
C. NOMOUNT
D. STARTUP FORCE
Answer: C
Rationale: An Oracle instance is initialized during the
NOMOUNT phase. The Oracle executable reads the
initialization parameters from the PFILE or SPFILE to
allocate the System Global Area (SGA) and start
background processes.
3. If an administrator issues the ALTER SYSTEM SET
SGA_TARGET=4G SCOPE=MEMORY; command, when
does the change take effect?
A. Immediately for the current instance only
B. Immediately and permanently across restarts
C. Only after the next instance reboot
D. Only when the current sessions disconnect
Answer: A
, Rationale: The SCOPE=MEMORY clause specifies that
the parameter change takes effect immediately but is
transient. Because it is not written to the SPFILE, the
change will be lost upon the next database reboot.
4. Which background process is responsible for performing
instance recovery when a database restarts after an
unexpected crash?
A. PMON (Process Monitor)
B. DBWn (Database Writer)
C. SMON (System Monitor)
D. LGWR (Log Writer)
Answer: C
Rationale: SMON (System Monitor) automatically
performs instance recovery at startup if the database
was closed cleanly. It rolls forward changes in the
online redo logs (cache recovery) and rolls back
uncommitted transactions (transaction recovery).
5. A user process terminates abnormally due to a network
disconnect. Which background process is responsible for
cleaning up the user's locks and releasing their allocated
SGA resources?
A. SMON
B. PMON
C. CKPT
D. RECO
, Answer: B
Rationale: PMON (Process Monitor) monitors
background and user processes. When a user process
fails or terminates abnormally, PMON cleans up the
software cache, releases user locks, and frees up
resources assigned to that specific process.
6. Which initialization parameter determines the maximum
number of simultaneous user sessions that can connect to
the database instance?
A. PROCESSES
B. SESSIONS
C. TRANSACTIONS
D. SGA_MAX_SIZE
Answer: B
Rationale: The SESSIONS parameter explicitly sets the
maximum number of sessions. By default, Oracle
derives this value from the PROCESSES parameter
formula, but it can be set independently to cap active
connections.
7. Which shutdown mode requires instance recovery during
the next subsequent startup operation?
A. SHUTDOWN NORMAL
B. SHUTDOWN IMMEDIATE
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN ABORT
PREP VERIFIED QUESTIONS, ANSWERS & RATIONALES
(LATEST 2026 EDITION)
This comprehensive mock exam bank provides verified
questions, answers, and deep-dive rationales tailored
specifically for the Western Governors University D330 objective
assessment. It systematically covers core Oracle Database
Administration concepts including instance management,
SGA/PGA memory architecture, physical storage, network
configuration, and user security auditing. Mastering these high-
yield practice questions ensures a thorough understanding of
the exam material and provides an excellent path to passing on
your first attempt.
Part 1: Database Architecture & Instance Management
1. Which file must be accessible to transition an Oracle
database instance from the NOMOUNT state to the
MOUNT state?
A. Data file
B. Control file
C. Redo log file
D. Password file
Answer: B
Rationale: The control file contains the physical
structure of the database, including data file and redo
log locations. Moving from NOMOUNT (where only
, memory and background processes exist) to MOUNT
requires reading the control file specified in the
initialization parameter file. Data files and redo logs are
only opened during the transition from MOUNT to
OPEN.
2. During which stage of database startup is the server
parameter file (SPFILE) read?
A. MOUNT
B. OPEN
C. NOMOUNT
D. STARTUP FORCE
Answer: C
Rationale: An Oracle instance is initialized during the
NOMOUNT phase. The Oracle executable reads the
initialization parameters from the PFILE or SPFILE to
allocate the System Global Area (SGA) and start
background processes.
3. If an administrator issues the ALTER SYSTEM SET
SGA_TARGET=4G SCOPE=MEMORY; command, when
does the change take effect?
A. Immediately for the current instance only
B. Immediately and permanently across restarts
C. Only after the next instance reboot
D. Only when the current sessions disconnect
Answer: A
, Rationale: The SCOPE=MEMORY clause specifies that
the parameter change takes effect immediately but is
transient. Because it is not written to the SPFILE, the
change will be lost upon the next database reboot.
4. Which background process is responsible for performing
instance recovery when a database restarts after an
unexpected crash?
A. PMON (Process Monitor)
B. DBWn (Database Writer)
C. SMON (System Monitor)
D. LGWR (Log Writer)
Answer: C
Rationale: SMON (System Monitor) automatically
performs instance recovery at startup if the database
was closed cleanly. It rolls forward changes in the
online redo logs (cache recovery) and rolls back
uncommitted transactions (transaction recovery).
5. A user process terminates abnormally due to a network
disconnect. Which background process is responsible for
cleaning up the user's locks and releasing their allocated
SGA resources?
A. SMON
B. PMON
C. CKPT
D. RECO
, Answer: B
Rationale: PMON (Process Monitor) monitors
background and user processes. When a user process
fails or terminates abnormally, PMON cleans up the
software cache, releases user locks, and frees up
resources assigned to that specific process.
6. Which initialization parameter determines the maximum
number of simultaneous user sessions that can connect to
the database instance?
A. PROCESSES
B. SESSIONS
C. TRANSACTIONS
D. SGA_MAX_SIZE
Answer: B
Rationale: The SESSIONS parameter explicitly sets the
maximum number of sessions. By default, Oracle
derives this value from the PROCESSES parameter
formula, but it can be set independently to cap active
connections.
7. Which shutdown mode requires instance recovery during
the next subsequent startup operation?
A. SHUTDOWN NORMAL
B. SHUTDOWN IMMEDIATE
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN ABORT
