WGU D330 DATA SYSTEMS ADMINISTRATION COMPREHENSIVE STUDY GUIDE 2026 FULL QUESTIONS AND SOLUTIONS GRADED A+

WGU D330 DATA SYSTEMS
ADMINISTRATION COMPREHENSIVE
STUDY GUIDE 2026 FULL QUESTIONS AND
SOLUTIONS GRADED A+

◍ Which parameter can an administrator enable without restarting a database?
A. COMPATIBLE
B. DB_DOMAIN
C. SGA_TARGET
D. UNDO_MANAGEMENT.
Answer: 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.
Answer: A. V$SPPARAMETER
◍ Which command performs a clean shutdown without waiting for clients to
disconnect?
A. SHUTDOWN ABORT
B. SHUTDOWN NORMAL
C. SHUTDOWN TRANSACTIONAL
D. SHUTDOWN IMMEDIATE.
Answer: 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.
Answer: 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.
Answer: D. Tablespace creation
◍ 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.
Answer: 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.
Answer: 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.
Answer: 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.
Answer: 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.
Answer: 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?
A. scott.employee@wgu2021
B. scott.employee
C. employee
D. scott.employee@test.
Answer: A. scott.employee@wgu2021
◍ Which information from a remote database is included in the configuration
of a database link?
A. User name
B. Data files
C. Tables
D. Views.
Answer: A. User name
◍ Which object can be added to an existing bigfile tablespace?
A. datafiletemp table
B. table data
C. tablespacedictionary table
D. undo data.

, Answer: B. table data
◍ What is the purpose of the undo tablespace?
A. To manage space for sort operations
B. To facilitate the rollback of transactions
C. To allocate space for SQL cursors
D. To maintain the Automatic Workload Repository.
Answer: B. To facilitate the rollback of transactions
◍ Which dictionary view is available in the database to view segment advisor
results?
A. DBA_ADVISOR_TASKS
B. DBA_ADVISOR_TEMPLATES
C. DBA_ADVISOR_OBJECTS
D. DBA_ADVISOR_USAGE.
Answer: C. DBA_ADVISOR_OBJECTS
◍ A database administrator needs to recover unused space from a tablespace
while preventing data loss. What should the administrator use?
A. The SHRINK option
B. The DROP command
C. The FLASHBACK command
D. The OFFLINE clause.
Answer: A. the SHRINK option
◍ Which package should an administrator use to configure local extent
management for tablespaces?
A. DBMS_SPACE_ADMIN
B. DBMS_AUDIT_MGMT
C. DBMS_TRANSFORM
D. DBMS_METADATA.
Answer: A. DBMS_SPACE_ADMIN
◍ What should an administrator use to identify tables that are fragmented?
A. Segment Advisor
B. Automatic Database Diagnostic Monitor