ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-084 All Questions

View all questions & answers for the 1z0-084 exam
Go to Exam

Exam 1z0-084 topic 1 question 6 discussion

Actual exam question from Oracle's 1z0-084
Question #: 6
Topic #: 1
[All 1z0-084 Questions]

You execute the following:
EXECUTE DBMS_AUTO_TASK_ADMIN.DISABLE;
Which advisor remains enabled?

  • A. Automatic SQL Tuning
  • B. SQL Plan Management Evolve Advisor
  • C. Optimizer Statistics Advisor
  • D. Automatic Optimizer Statistics Collection
  • E. Automatic Segment Advisor
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by ScottL at Sept. 26, 2024, 3:13 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
d87d280
1 month, 1 week ago
Selected Answer: E
Read carefully, it says advisor and the Oracle note is very clarifying, be careful there DBMS_AUTO_TASK_ADMIN.DISABLE still shows the client_name enabled in DBA_AUTOTASK_CLIENT view (Doc ID 1565768.1). advisor says
upvoted 1 times
...
Yoones
3 months, 2 weeks ago
Selected Answer: D
D is cirrect
upvoted 1 times
...
krwi1
4 months ago
Selected Answer: B
I think B D is wrong - select client_name from dba_autotask_client; auto optimizer stats collection auto space advisor sql tuning advisor
upvoted 1 times
...
cujar2003
9 months, 2 weeks ago
D Automatic Optimizer Statistics Collection is not an advisor
upvoted 1 times
...
ScottL
10 months ago
Selected Answer: D
It could be argued that Automatic Optimizer Statistics Collection is not an advisor.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel