WGU D330 OBJECTIVE ASSESSMENT FINAL NEWEST
2026/ 2027 ACTUAL EXAM TEST BANK| D330 DATA
SYSTEMS ADMINISTRATION OA FINAL REVIEW
WITH 400 REAL EXAM QUESTIONS AND CORRECT
VERIFIED ANSWERS/ GRADED A+ (MOST RECENT!!)
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 – Correct Answer - A. Enabling the retention
guarantee
An administrator plans to use SQL*Loader to import a data file using a
fixed-width format.
Which file must be configured before importing the file?
A. Control
B. Data
C. Bad
D. Discard – Correct Answer - A. Control
Which tool identifies potential performance bottlenecks?
A. Cluster Verification Utility
B. Automatic Database Diagnostic Monitor
pg. 1
,C. Oracle Data Guard Broker
D. Privilege Analysis – Correct Answer - B. Automatic Database
Diagnostic Monitor
Which tool contains procedures to collect performance information on
database objects?
A. DBMS_STATS
B. Automated Maintenance Tasks
C. DBMS_WORKLOAD_REPOSITORY
D. Cost-based optimizer – Correct Answer - A. DBMS_STATS
Which tool is started by the system and automatically improves the
performance of queries?
A. SQL Tuning Advisor
B. SQL*Loader
C. SQL Access Advisor
D. SQL*Plus – Correct Answer - A. SQL Tuning Advisor
Which additional information can administrators collect by configuring
the Automatic Workload Repository (AWR) to use the ALL statistics
collection level?
A. Row count
B. Execution plan
C. Table histogram
D. Column density – Correct Answer - B. Execution plan
pg. 2
,Which parameter is used when creating a user account that will be
authenticated by the operating system?
A. GLOBALLY
B. VALUES
C. USING
D. EXTERNALLY – Correct Answer - D. EXTERNALLY
A user creates a role granting select and update access to table1, and
assigns the role to a coworker. The next day the user revokes select
access from the role.
Which actions will the coworker still be able to perform on table1?
A. Modify
B. Display
C. Add
D. Delete – Correct Answer - A. Modify
A user needs to view the table privileges of other users.
Which role should be granted to the user?
A. SELECT_CATALOG_ROLE
B. CONNECT
C. EXECUTE_CATALOG_ROLE
D. RESOURCE – Correct Answer - A. SELECT_CATALOG_ROLE
After an administrator granted some privileges to a user, all database
users automatically had those same privileges.
Which user was assigned the privileges?
pg. 3
, A. PUBLIC
B. SCOTT
C. SYSTEM
D. DBSNMP – Correct Answer - A. PUBLIC
An administrator wants to limit CPU time for accounts.
Which object should the administrator alter?
A. Profile
B. Role
C. Tablespace
D. Schema – Correct Answer - A. Profile
In response to users' complaints that the system is slow, a database
administrator detects that a user is consuming too many resources.
Which parameter controls the use of service units?
A. CPU_PER_CALL
B. CPU_PER_SESSION
C. COMPOSITE_LIMIT
D. ASM_POWER_LIMIT – Correct Answer - C. COMPOSITE_LIMIT
An administrator creates a user profile that forces a change to the user's
password at the first login.
Which clause did the administrator include in the create user statement?
A. BY PASSWORD
B. ACCOUNT LOCK
pg. 4
2026/ 2027 ACTUAL EXAM TEST BANK| D330 DATA
SYSTEMS ADMINISTRATION OA FINAL REVIEW
WITH 400 REAL EXAM QUESTIONS AND CORRECT
VERIFIED ANSWERS/ GRADED A+ (MOST RECENT!!)
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 – Correct Answer - A. Enabling the retention
guarantee
An administrator plans to use SQL*Loader to import a data file using a
fixed-width format.
Which file must be configured before importing the file?
A. Control
B. Data
C. Bad
D. Discard – Correct Answer - A. Control
Which tool identifies potential performance bottlenecks?
A. Cluster Verification Utility
B. Automatic Database Diagnostic Monitor
pg. 1
,C. Oracle Data Guard Broker
D. Privilege Analysis – Correct Answer - B. Automatic Database
Diagnostic Monitor
Which tool contains procedures to collect performance information on
database objects?
A. DBMS_STATS
B. Automated Maintenance Tasks
C. DBMS_WORKLOAD_REPOSITORY
D. Cost-based optimizer – Correct Answer - A. DBMS_STATS
Which tool is started by the system and automatically improves the
performance of queries?
A. SQL Tuning Advisor
B. SQL*Loader
C. SQL Access Advisor
D. SQL*Plus – Correct Answer - A. SQL Tuning Advisor
Which additional information can administrators collect by configuring
the Automatic Workload Repository (AWR) to use the ALL statistics
collection level?
A. Row count
B. Execution plan
C. Table histogram
D. Column density – Correct Answer - B. Execution plan
pg. 2
,Which parameter is used when creating a user account that will be
authenticated by the operating system?
A. GLOBALLY
B. VALUES
C. USING
D. EXTERNALLY – Correct Answer - D. EXTERNALLY
A user creates a role granting select and update access to table1, and
assigns the role to a coworker. The next day the user revokes select
access from the role.
Which actions will the coworker still be able to perform on table1?
A. Modify
B. Display
C. Add
D. Delete – Correct Answer - A. Modify
A user needs to view the table privileges of other users.
Which role should be granted to the user?
A. SELECT_CATALOG_ROLE
B. CONNECT
C. EXECUTE_CATALOG_ROLE
D. RESOURCE – Correct Answer - A. SELECT_CATALOG_ROLE
After an administrator granted some privileges to a user, all database
users automatically had those same privileges.
Which user was assigned the privileges?
pg. 3
, A. PUBLIC
B. SCOTT
C. SYSTEM
D. DBSNMP – Correct Answer - A. PUBLIC
An administrator wants to limit CPU time for accounts.
Which object should the administrator alter?
A. Profile
B. Role
C. Tablespace
D. Schema – Correct Answer - A. Profile
In response to users' complaints that the system is slow, a database
administrator detects that a user is consuming too many resources.
Which parameter controls the use of service units?
A. CPU_PER_CALL
B. CPU_PER_SESSION
C. COMPOSITE_LIMIT
D. ASM_POWER_LIMIT – Correct Answer - C. COMPOSITE_LIMIT
An administrator creates a user profile that forces a change to the user's
password at the first login.
Which clause did the administrator include in the create user statement?
A. BY PASSWORD
B. ACCOUNT LOCK
pg. 4
