← Quiz: Query Processing and Optimization: all 10 questions
Quiz: Query Processing and Optimization · Question 5 of 10
Which join algorithm can handle a condition like r.salary < s.limit?
Which join algorithm can handle a condition like r.salary < s.limit?
- A.Hash join
- B.Sort-merge join
- C.Nested loop join
- D.None of them
Answer & explanation
Correct answer: Nested loop join
Hash and sort-merge joins need an equality condition; nested loop works for any condition.
Can you get the rest right without peeking?
Take the timed Quiz: Query Processing and Optimization quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →