WGU D330 DATA SYSTEMS
ADMINISTRATION EXAM 2026-2027
QUESTIONS AND ANSWERS GRADED A+
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
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 information from a remote database is included in the configuration of a
database link?
A. User name
B. Data files
C. Tables
D. Views
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
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
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
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
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
A. DBMS_SPACE_ADMIN
What should an administrator use to identify tables that are fragmented?
A. Segment Advisor
B. Automatic Database Diagnostic Monitor
C. DBMS_SPACE
D. DBMS_REPAIR
A. segment advisor
ADMINISTRATION EXAM 2026-2027
QUESTIONS AND ANSWERS GRADED A+
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
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 information from a remote database is included in the configuration of a
database link?
A. User name
B. Data files
C. Tables
D. Views
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
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
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
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
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
A. DBMS_SPACE_ADMIN
What should an administrator use to identify tables that are fragmented?
A. Segment Advisor
B. Automatic Database Diagnostic Monitor
C. DBMS_SPACE
D. DBMS_REPAIR
A. segment advisor
