Oracle
1Z0-074 · Question #96
Which two statements are true about a band join? (Choose two.)
The correct answer is C. It is a non-equijoin in which the key values in one data set must fall within the specified range of the E. The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges. Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgsql/joins.html#GUID-24F34188-110F- 4245-9DE7-43954092AFE0
New Features for Performance
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.
How the community answered
(19 responses)- A16% (3)
- C79% (15)
- D5% (1)
Explanation
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgsql/joins.html#GUID-24F34188-110F- 4245-9DE7-43954092AFE0
Topics
#band join#non-equijoin#query optimizer#join execution
Community Discussion
No community discussion yet for this question.