Home » MCQs » DBMS MCQs » DBMS Merge Join Algorithm MCQs

Prior to applying the merge join algorithm, we must ____ the given input relations r and s if any of the join attributes are not sorted

8. Prior to applying the merge join algorithm, we must ____ the given input relations r and s if any of the join attributes are not sorted.

1. Query
2. Add
3. Delete
4. Sort

Answer: D) Sort

Explanation:

Prior to applying the merge join algorithm, we must sort the given input relations r and s if any of the join attributes are not sorted.