WGU D330 Data Systems
Administration: The Ultimate
Question Practice Exam with Answer
Rationales
## SECTION 1: ORACLE DATABASE ARCHITECTURE & INSTANCE
MANAGEMENT (Questions 1-40)
### Question 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. Control file**
**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.
---
### Question 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. NOMOUNT**
**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.
---
### Question 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. Immediately for the current instance only**
**Rationale:** SCOPE=MEMORY applies the parameter change only to
the current running instance. The change is not persisted to the SPFILE,
so it will be lost after a database restart.
---
### Question 4
, **Which background process cleans up failed processes and releases
resources?**
A. Log Writer (LGWR)
B. Database Writer (DBWn)
C. System Monitor (SMON)
D. Process Monitor (PMON)
**Answer: D. Process Monitor (PMON)**
**Rationale:** PMON 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.
---
### Question 5
**Which initialization parameter determines the maximum number of
simultaneous user sessions that can connect to the database
instance?**
A. PROCESSES
B. SESSIONS
Administration: The Ultimate
Question Practice Exam with Answer
Rationales
## SECTION 1: ORACLE DATABASE ARCHITECTURE & INSTANCE
MANAGEMENT (Questions 1-40)
### Question 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. Control file**
**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.
---
### Question 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. NOMOUNT**
**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.
---
### Question 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. Immediately for the current instance only**
**Rationale:** SCOPE=MEMORY applies the parameter change only to
the current running instance. The change is not persisted to the SPFILE,
so it will be lost after a database restart.
---
### Question 4
, **Which background process cleans up failed processes and releases
resources?**
A. Log Writer (LGWR)
B. Database Writer (DBWn)
C. System Monitor (SMON)
D. Process Monitor (PMON)
**Answer: D. Process Monitor (PMON)**
**Rationale:** PMON 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.
---
### Question 5
**Which initialization parameter determines the maximum number of
simultaneous user sessions that can connect to the database
instance?**
A. PROCESSES
B. SESSIONS
