Oracle
1Z0-074 · Question #96
1Z0-074 Question #96: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #96. The question stem and answer options stay visible for context.
Question
Which two statements are true about a band join? (Choose two.)
Options
- AThe optimizer always uses the smaller of the two row sources to build a hash table on the join key.
- CIt is a non-equijoin in which the key values in one data set must fall within the specified range of the
- DFor each row in the first row source, Oracle probes the second row source for matching rows and joins
- EThe SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.
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.