Multiple choice

Which of the following joins in relational algebra records from both the files P and Q are hashed to a single hash file by utilising the same function on the join attributes M of X and N of Y as hash keys?

  1. Nested loop join

  2. Single loop join

  3. Sort merge join

  4. Hash join

  5. Equi join

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This is the correct answer.