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

In a situation where the buffer size is small enough to store the entire relationship in memory, the ____ nested-loop join saves the need for major ____ accesses

8. In a situation where the buffer size is small enough to store the entire relationship in memory, the ____ nested-loop join saves the need for major ____ accesses.

1. Block
2. Inner
3. Outer
4. None

Answer: A) Block

Explanation:

In a situation where the buffer size is small enough to store the entire relationship in memory, the block nested-loop join saves the need for major block accesses.