WGU D330 DATA SYSTEMS ADMINISTRATION
WGU D330 DATA SYSTEMS ADMINISTRATION
FINAL EXAM 2024/2025 VERIFIED QUESTIONS
AND ANSWERS WITH RATIONALE
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
Which command performs a clean shutdown without waiting for clients to disconnect?
,WGU D330 DATA SYSTEMS ADMINISTRATION
A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN IMMEDIATE
D. SHUTDOWN IMMEDIATE
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
Which types of events are recorded in an alert log?
A. Package creation
B. User creation
C. Role creation
D. Tablespace creation
D. Tablespace creation
,WGU D330 DATA SYSTEMS ADMINISTRATION
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
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
, WGU D330 DATA SYSTEMS ADMINISTRATION
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
Which net service naming method requires the client to use a fixed port number?
A. Local
B. External
C. Host
D. Directory
C. Host
A database link named wgu2021 has been created to link to a remote object in the test database.
The object is named employee and is owned by Scott.
Which reference resolves to the remote object?
WGU D330 DATA SYSTEMS ADMINISTRATION
FINAL EXAM 2024/2025 VERIFIED QUESTIONS
AND ANSWERS WITH RATIONALE
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
Which command performs a clean shutdown without waiting for clients to disconnect?
,WGU D330 DATA SYSTEMS ADMINISTRATION
A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN IMMEDIATE
D. SHUTDOWN IMMEDIATE
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
Which types of events are recorded in an alert log?
A. Package creation
B. User creation
C. Role creation
D. Tablespace creation
D. Tablespace creation
,WGU D330 DATA SYSTEMS ADMINISTRATION
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
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
, WGU D330 DATA SYSTEMS ADMINISTRATION
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
Which net service naming method requires the client to use a fixed port number?
A. Local
B. External
C. Host
D. Directory
C. Host
A database link named wgu2021 has been created to link to a remote object in the test database.
The object is named employee and is owned by Scott.
Which reference resolves to the remote object?
