Multiple choice technology

Which two statements are true about the join stage?

  1. All the inputs to join stage must be sorted by join key

  2. The join stage supports inner, left outer, and right outer joins

  3. Both

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Join stage requires all inputs to be sorted by the join key columns (requirement for merge join operation), and it supports inner, left outer, and right outer join types. Both statements are true about Join stage behavior.

Keep practicing — related questions