Oracle
1Z0-074 · Question #7
In which situation can the optimizer choose a hash join?
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
Displaying Data from Multiple Tables Using Joins
Question
In which situation can the optimizer choose a hash join?
Options
- Awhen a non-equijoin is used and the join column in at least one of the tables is a primary key
- Bwhen a non-equijoin is used and the join column for both tables is a primary key
- Cwhen a non-equijoin is used between a table and a sorted hash cluster
- Dwhen an equality operator is used
- Ewhen any self-join is done
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#hash join#query optimizer#equality join#join selection