WGU D330 Data Systems Administration
WGU D330 Data Systems Administration Final Exam 2025
Study Questions And Answers Graded A+
Which feature allows a failed transaction to be suspended until the problem that
caused the failure is resolved?
A. Resumable space allocation
B. Segment shrinking
C. Instance recovery
D. Oracle managed files
A. Resumable space allocation
Which view has space information?
A. DBA_OBJECTS
B. V$TABLESPACE
C. V$SQLTEXT
D. DBA_DATA_FILES
D. DBA_DATA_FILES
,WGU D330 Data Systems Administration
An administrator attempts to roll back a transaction from the previous day. The
rollback attempt fails.
Which action will prevent the failure from recurring?
A. Enabling the retention guarantee
B. Setting the session to be resumable
C. Flushing the log buffer
D. Restarting the database
A. Enabling the retention guarantee
Which initialization parameter sets the location of the alert log?
A. AUDIT_FILE_DEST
B. LOG_ARCHIVE_DEST
C. DIAGNOSTIC_DEST
D. CORE_DUMP_DEST
C. DIAGNOSTIC_DEST
Where is the listener.ora file located by default?
A. $ORACLE_HOME/RDBMS
,WGU D330 Data Systems Administration
B. $ORACLE_HOME/NETWORK/ADMIN
C. $ORACLE_HOME/DATABASE/ADMIN
D. $ORACLE_HOME/DBS/ADMIN
B. $ORACLE_HOME/NETWORK/ADMIN
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
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
, WGU D330 Data Systems Administration
Which parameter can an administrator enable without restarting a database?
A. COMPATIBLE
B. DB_DOMAIN
C. SGA_TARGET
D. UNDO_MANAGEMENT
C. SGA_TARGET
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$PARAMETER
A. V$SPPARAMETER
WGU D330 Data Systems Administration Final Exam 2025
Study Questions And Answers Graded A+
Which feature allows a failed transaction to be suspended until the problem that
caused the failure is resolved?
A. Resumable space allocation
B. Segment shrinking
C. Instance recovery
D. Oracle managed files
A. Resumable space allocation
Which view has space information?
A. DBA_OBJECTS
B. V$TABLESPACE
C. V$SQLTEXT
D. DBA_DATA_FILES
D. DBA_DATA_FILES
,WGU D330 Data Systems Administration
An administrator attempts to roll back a transaction from the previous day. The
rollback attempt fails.
Which action will prevent the failure from recurring?
A. Enabling the retention guarantee
B. Setting the session to be resumable
C. Flushing the log buffer
D. Restarting the database
A. Enabling the retention guarantee
Which initialization parameter sets the location of the alert log?
A. AUDIT_FILE_DEST
B. LOG_ARCHIVE_DEST
C. DIAGNOSTIC_DEST
D. CORE_DUMP_DEST
C. DIAGNOSTIC_DEST
Where is the listener.ora file located by default?
A. $ORACLE_HOME/RDBMS
,WGU D330 Data Systems Administration
B. $ORACLE_HOME/NETWORK/ADMIN
C. $ORACLE_HOME/DATABASE/ADMIN
D. $ORACLE_HOME/DBS/ADMIN
B. $ORACLE_HOME/NETWORK/ADMIN
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
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
, WGU D330 Data Systems Administration
Which parameter can an administrator enable without restarting a database?
A. COMPATIBLE
B. DB_DOMAIN
C. SGA_TARGET
D. UNDO_MANAGEMENT
C. SGA_TARGET
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$PARAMETER
A. V$SPPARAMETER
