Page 1 of 172
WGU D330 - DATA SYSTEMS ADMINISTRATION
EXAM | OBJECTIVE ASSESSMENT 2 | {LATEST
2026/ 2027 UPDATE} COMPLETE ACTUAL AND
AUTHENTIC EXAM | BRAND NEW!
Which two parameters configure automatic PGA memory
management?
A. SGA_TARGET
B. PGA_AGGREGATE_TARGET
C. WORKAREA_SIZE_POLICY
D. PGA_AGGREGATE_LIMIT
B. PGA_AGGREGATE_TARGET
C. WORKAREA_SIZE_POLICY
When the WORKAREA_SIZE_POLICY is set to AUTO, work areas used
by memoryintensive operations are sized automatically, based on the
PGA memory used by the system, and the target PGA memory set in
PGA_AGGREGATE_TARGET. When WORKAREA_ SIZE_POLICY is set to
,Page 2 of 172
MANUAL, the *_AREA_SIZE parameters need to be configured
manually.
You've noticed that when an instance crashes, it takes a long time to
start up the database. Which advisor can be used to tune this
situation?
A. The Undo Advisor
B. The SQL Tuning Advisor
C. The Database Tuning Advisor
D. The MTTR Advisor
E. The Instance Tuning Advisor
D. The MTTR Advisor
The MTTR Advisor can tell the DBA the most effective value for the
FAST_START_ MTTR_TARGET parameter. This parameter specifies the
maximum time required in seconds to perform instance recovery
Suppose you have used EM Database Control to drill down into ADDM
findings and have found that a single SQL statement is causing the
,Page 3 of 172
majority of the I/O on your system. Which of the following advisors is
best suited to troubleshoot this SQL statement?
A. SQL Tuning Advisor
B. SQL Access Advisor
C. Both A and B
D. Neither A nor B
C. Both A and B
You can use the SQL Tuning Advisor to determine if there is a better
optimizer plan and use SQL Access Advisor to determine if creating an
index or materialized view would improve performance. These tools
together can be used to determine whether I/O can be minimized and
overall DB Time reduced to the targeted SQL statement.
Suppose you have used EM Database Control to drill down into ADDM
findings and have found that a single SQL statement is causing the
majority of the I/O on your system. Which of the following advisors is
best suited to troubleshoot this SQL statement?
A. SQL Tuning Advisor
, Page 4 of 172
B. SQL Access Advisor
C. Both A and B
D. Neither A nor B
C. Both A and B
The log buffer cannot be dynamically resized once the instance is
started. There is rarely a need to dynamically adjust the redo log
buffer. All other components in the SGA can be dynamically modified.
Which procedure is used to tell Oracle that the statistics gathered
should not be published?
A. DBMS_STATS.PUBLISH_STATS
B. DBMS_STATS.SET_TABLE_PREFS
C. DBMS_STATS.PENDING_STATS
D. DBMS_STATS.GATHER_TABLE_STATS
B. DBMS_STATS.SET_TABLE_PREFS
The DBMS_STATS.SET_TABLE_PREFS procedure is used to set the
PUBLISH preference to FALSE. To be able to use the pending statistics,
the OPTIMIZER_USE_PENDING_STATISTICS parameter must be set to
TRUE in the session.
WGU D330 - DATA SYSTEMS ADMINISTRATION
EXAM | OBJECTIVE ASSESSMENT 2 | {LATEST
2026/ 2027 UPDATE} COMPLETE ACTUAL AND
AUTHENTIC EXAM | BRAND NEW!
Which two parameters configure automatic PGA memory
management?
A. SGA_TARGET
B. PGA_AGGREGATE_TARGET
C. WORKAREA_SIZE_POLICY
D. PGA_AGGREGATE_LIMIT
B. PGA_AGGREGATE_TARGET
C. WORKAREA_SIZE_POLICY
When the WORKAREA_SIZE_POLICY is set to AUTO, work areas used
by memoryintensive operations are sized automatically, based on the
PGA memory used by the system, and the target PGA memory set in
PGA_AGGREGATE_TARGET. When WORKAREA_ SIZE_POLICY is set to
,Page 2 of 172
MANUAL, the *_AREA_SIZE parameters need to be configured
manually.
You've noticed that when an instance crashes, it takes a long time to
start up the database. Which advisor can be used to tune this
situation?
A. The Undo Advisor
B. The SQL Tuning Advisor
C. The Database Tuning Advisor
D. The MTTR Advisor
E. The Instance Tuning Advisor
D. The MTTR Advisor
The MTTR Advisor can tell the DBA the most effective value for the
FAST_START_ MTTR_TARGET parameter. This parameter specifies the
maximum time required in seconds to perform instance recovery
Suppose you have used EM Database Control to drill down into ADDM
findings and have found that a single SQL statement is causing the
,Page 3 of 172
majority of the I/O on your system. Which of the following advisors is
best suited to troubleshoot this SQL statement?
A. SQL Tuning Advisor
B. SQL Access Advisor
C. Both A and B
D. Neither A nor B
C. Both A and B
You can use the SQL Tuning Advisor to determine if there is a better
optimizer plan and use SQL Access Advisor to determine if creating an
index or materialized view would improve performance. These tools
together can be used to determine whether I/O can be minimized and
overall DB Time reduced to the targeted SQL statement.
Suppose you have used EM Database Control to drill down into ADDM
findings and have found that a single SQL statement is causing the
majority of the I/O on your system. Which of the following advisors is
best suited to troubleshoot this SQL statement?
A. SQL Tuning Advisor
, Page 4 of 172
B. SQL Access Advisor
C. Both A and B
D. Neither A nor B
C. Both A and B
The log buffer cannot be dynamically resized once the instance is
started. There is rarely a need to dynamically adjust the redo log
buffer. All other components in the SGA can be dynamically modified.
Which procedure is used to tell Oracle that the statistics gathered
should not be published?
A. DBMS_STATS.PUBLISH_STATS
B. DBMS_STATS.SET_TABLE_PREFS
C. DBMS_STATS.PENDING_STATS
D. DBMS_STATS.GATHER_TABLE_STATS
B. DBMS_STATS.SET_TABLE_PREFS
The DBMS_STATS.SET_TABLE_PREFS procedure is used to set the
PUBLISH preference to FALSE. To be able to use the pending statistics,
the OPTIMIZER_USE_PENDING_STATISTICS parameter must be set to
TRUE in the session.
