1 | Page
WGU D330 PRE ASSESSMENT ACTUAL EXAM PREP 2026
ALL QUESTIONS AND CORRECT VERIFIED ANSWERS
|RATED A+ |BRAND NEW AND REVISED
1. Which parameter can an administrator enable without restarting a data-base?
A. COMPATIBLE
B. DB_DOMAIN
C. SGA_TARGET
D. UNDO_MANAGEMENT: C. SGA_TARGET
2. Which view displays database parameters and values modified using the
SCOPE=SPFILE clause?
A. V$SPPARAMETER
B. V$NLS_PARAMETER
C. V$HS_PARAMETER
D. V$PARAM ETER: A. V$SPPARAMETER
3. Which command performs a clean shutdown without waiting for clients to
disconnect?
A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDO W N IMMEDIATE: D. SHUTDOW N IMMEDIATE
4. Which area is a member of the System Global Area (SGA)?
A. Java pool
B. Log writer
C. Database writer
D. Process monitor: A. Java Pool
5. Which types of events are recorded in an alert log?
,2 | Page
A. Package creation
B. User creation
C. Role creation
D. Tablespace creation: D. Tablespace creation
,3 | Page
6. Which initialization parameter sets the location of the alert log?
A. AUDIT_FILE_DEST
B. LOG_ARCHIVE_DEST
C. DIAGNOSTIC_DEST
D. CORE_DU MP_DEST: C. DIAGNOSTIC_DEST
7. Where is the listener.ora file located by default?
A. $ORACLE_HOME/RDBMS
B. $ORACLE_HOME/NETWORK/ADMIN
C. $ORACLE_HOME/DATABASE/ADMIN
D. $ORACLE_HOME/DBS/ADMIN: B. $ORACLE_HOME/NETWORK/ADMIN
8. Which type of connection uses the Oracle Listener to communicate?
A. Client with database server
B. Browser with application server
C. Two application servers
D. Client with backup tool: A. Client with database server
9. What does the SERVER=DEDICATED element in a tnsnames.ora file associate with
each client connection?
A. A committed server process
B. A shared server process
C. A pooled server process
D. A dispatched server process: A. A committed server process
10. Which net service naming method requires the client to use a fixed port
number?
A. Local
B. External
C. Host
D. Directory: C. Host
WGU D330 PRE ASSESSMENT ACTUAL EXAM PREP 2026
ALL QUESTIONS AND CORRECT VERIFIED ANSWERS
|RATED A+ |BRAND NEW AND REVISED
1. Which parameter can an administrator enable without restarting a data-base?
A. COMPATIBLE
B. DB_DOMAIN
C. SGA_TARGET
D. UNDO_MANAGEMENT: C. SGA_TARGET
2. Which view displays database parameters and values modified using the
SCOPE=SPFILE clause?
A. V$SPPARAMETER
B. V$NLS_PARAMETER
C. V$HS_PARAMETER
D. V$PARAM ETER: A. V$SPPARAMETER
3. Which command performs a clean shutdown without waiting for clients to
disconnect?
A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDO W N IMMEDIATE: D. SHUTDOW N IMMEDIATE
4. Which area is a member of the System Global Area (SGA)?
A. Java pool
B. Log writer
C. Database writer
D. Process monitor: A. Java Pool
5. Which types of events are recorded in an alert log?
,2 | Page
A. Package creation
B. User creation
C. Role creation
D. Tablespace creation: D. Tablespace creation
,3 | Page
6. Which initialization parameter sets the location of the alert log?
A. AUDIT_FILE_DEST
B. LOG_ARCHIVE_DEST
C. DIAGNOSTIC_DEST
D. CORE_DU MP_DEST: C. DIAGNOSTIC_DEST
7. Where is the listener.ora file located by default?
A. $ORACLE_HOME/RDBMS
B. $ORACLE_HOME/NETWORK/ADMIN
C. $ORACLE_HOME/DATABASE/ADMIN
D. $ORACLE_HOME/DBS/ADMIN: B. $ORACLE_HOME/NETWORK/ADMIN
8. Which type of connection uses the Oracle Listener to communicate?
A. Client with database server
B. Browser with application server
C. Two application servers
D. Client with backup tool: A. Client with database server
9. What does the SERVER=DEDICATED element in a tnsnames.ora file associate with
each client connection?
A. A committed server process
B. A shared server process
C. A pooled server process
D. A dispatched server process: A. A committed server process
10. Which net service naming method requires the client to use a fixed port
number?
A. Local
B. External
C. Host
D. Directory: C. Host
