Oracle
1Z0-074 · Question #7
1Z0-074 Question #7: Real Exam Question with Answer & Explanation
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.
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.