Oracle Exam 1Z0-084 Topic 1 Question 23 Discussion

Actual exam question for Oracle's 1Z0-084 exam

Question #: 23
Topic #: 1

[All 1Z0-084 Questions]

Which procedure gathers statistics that are always used in the generation of any execution plan?

ADBMS_STATS.GATHER_DICTIONARY_STATS

BDBMS_STATS.GATHER_FIXED_ OBJECTS_STATS

CDBMS_STATS.GATHER_DATABASE_STATS

DDBMS_STATS.GATHER_SYSTEM_STATS

Show Suggested Answer

Suggested Answer: E

The optimizer_adaptive_statistics parameter, when set to TRUE, enables the optimizer to use adaptive statistics, such as SQL Plan Directives, to help improve plans by automatically adjusting them based on the actual execution statistics.

Oracle Database SQL Tuning Guide, 19c

by Dwight at Sep 16, 2024, 08:20 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-084 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Sage

11 days ago

I'm not sure, but I think C) DBMS_STATS.GATHER_DATABASE_STATS could also be a valid option.

upvoted 0 times

...

Xenia

13 days ago

I agree with Murray, gathering dictionary stats is essential for generating execution plans.

upvoted 0 times

...

Murray

27 days ago

I think the answer is A) DBMS_STATS.GATHER_DICTIONARY_STATS.

upvoted 0 times

...