Exam 1Z0-084 Topic 7 Question 19 Discussion

Actual exam question for Oracle's 1Z0-084 exam
Question #: 19
Topic #: 7
You execute the following:
EXECUTE DBMS_AuTO_TASK_ADMIN.DISABLE;
Which advisor remains enabled?

Suggested Answer: D Vote an answer

When you executeDBMS_AUTO_TASK_ADMIN.DISABLE, it disables all automated maintenance tasks related to the Auto Task framework. This includes tasks such as the Automatic SQL Tuning Advisor, Automatic Segment Advisor, and others. However, the Automatic Optimizer Statistics Collection (D) remains enabled as it is not part of the Auto Task framework. The gathering of optimizer statistics is controlled separately and is a critical part of the database's self-tuning mechanism to ensure the optimizer has up-to-date information about the data distribution within tables and indexes.
References
* Oracle Database 19c PL/SQL Packages and Types Reference - DBMS_AUTO_TASK_ADMIN
* Oracle Database 19c Database Administrator's Guide - Managing Optimizer Statistics

by Glenn at Mar 24, 2026, 07:31 PM

Limited Time Offer

15%

Off

Get Premium 1Z0-084 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10