Home » MCQs » DBMS MCQs » DBMS Nested-Loop Join Algorithm MCQs

Rather than relying on disk blocks for the block nested-loop join algorithm, we can use the ____ size that will fit into memory while allowing enough room for buffers of the inner relations

15. Rather than relying on disk blocks for the block nested-loop join algorithm, we can use the ____ size that will fit into memory while allowing enough room for buffers of the inner relations.

1. Smallest
2. Tiny
3. Largest
4. None

Answer: C) Largest

Explanation:

Rather than relying on disk blocks for the block nested-loop join algorithm, we can use the largest size that will fit into memory while allowing enough room for buffers of the inner relations.