Oracle Exam 1Z0-084 Topic 10 Question 22 Discussion

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

Question #: 22
Topic #: 10

[All 1Z0-084 Questions]

Which Optimizer component helps decide whether to use a nested loop join or a hash join in an adaptive execution plan?

AStatistics Feedback

BSQL Plan Directives

CStatistics Collector

DAutomatic Reoptimization

EDynamic Statistics

Show Suggested Answer

Suggested Answer: C

In an adaptive execution plan, the Optimizer makes runtime decisions between nested loop and hash joins using a statistics collector. The collector is a row source that collects statistics about the rows it processes and can adapt the plan based on the number of rows processed.

Oracle Database SQL Tuning Guide, 19c

by Aliza at Sep 13, 2024, 03:23 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Margurite

2 months ago

I think the answer is option A. Statistics Feedback is crucial for the optimizer to make informed decisions, including the choice between nested loops and hash joins.

upvoted 0 times

Markus

1 months ago

E) Dynamic Statistics could provide additional information for the optimizer to make the decision.

upvoted 0 times

...

Tran

1 months ago

B) SQL Plan Directives may also play a role in determining the join method.

upvoted 0 times

...

Beth

1 months ago

A) Statistics Feedback is correct. It helps the optimizer choose between nested loop and hash join.

upvoted 0 times

...

Margart

2 months ago

Haha, this question is making my head spin. I'm just going to close my eyes and pick option D - Automatic Reoptimization, it sounds like the most interesting choice!

upvoted 0 times