Home » MCQs » DBMS MCQs » DBMS External Sort-Merge Algorithm MCQs

What is/are the two exception(s), every block in the relation is read and written only once during each pass?

12. What is/are the two exception(s), every block in the relation is read and written only once during each pass?

1. It is possible to produce a sorted result without writing the result to the disk on the final pass
2. The pass may not be able to read out or write some runs.
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

The two exception(s), every block in the relation is read and written only once during each pass are -

1. It is possible to produce a sorted result without writing the result to the disk on the final pass
2. The pass may not be able to read out or write some runs.