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

Nichelle

1 months ago

I always thought the optimizer was just a guy with a crystal ball and a dartboard, but I guess this DBMS_STATS stuff is the real deal. Time to start throwing darts at the data dictionary, I guess!

upvoted 0 times

Pura

16 days ago

D) DBMS_STATS.GATHER_SYSTEM_STATS

upvoted 0 times

...

Arthur

16 days ago

C) DBMS_STATS.GATHER_DATABASE_STATS

upvoted 0 times

...

Azalee

20 days ago

A) DBMS_STATS.GATHER_DICTIONARY_STATS

upvoted 0 times

...

Rosendo

1 months ago

This is a tricky one, but I think the answer is A. DBMS_STATS.GATHER_DICTIONARY_STATS, because the data dictionary is the foundation for the database, and its statistics are essential for the optimizer.

upvoted 0 times

...

Pamella

1 months ago

Hmm, I'm leaning towards C. DBMS_STATS.GATHER_DATABASE_STATS, as it collects statistics for the entire database, which should include all the necessary information for execution plan generation.

upvoted 0 times

Dana

4 days ago

I agree, gathering database stats seems like the most comprehensive option.

upvoted 0 times

...

Bettina

16 days ago

I think C is the right choice too. It covers the entire database.

upvoted 0 times

...

Floyd

1 months ago

I'm pretty sure the correct answer is D. DBMS_STATS.GATHER_SYSTEM_STATS, because it collects system-level statistics that are crucial for the optimizer to generate efficient execution plans.

upvoted 0 times

...

Scot

2 months ago

I think the answer is B. DBMS_STATS.GATHER_FIXED_OBJECTS_STATS, as it gathers statistics on fixed objects like the data dictionary, which are always used in execution plan generation.

upvoted 0 times

Viola

13 days ago

I'm not sure, but I think the answer might be C. DBMS_STATS.GATHER_DATABASE_STATS, as it gathers statistics that are always used in the generation of any execution plan.

upvoted 0 times

...

Veronica

17 days ago

I believe the correct answer is A. DBMS_STATS.GATHER_DICTIONARY_STATS, as it gathers statistics that are always used in the generation of any execution plan.

upvoted 0 times

...

Yolande

1 months ago

I think the answer is B. DBMS_STATS.GATHER_FIXED_OBJECTS_STATS, as it gathers statistics on fixed objects like the data dictionary, which are always used in execution plan generation.

upvoted 0 times

...