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

A nested-loop join with blocks of the inner relation paired with blocks of the outer relation is known as a ____ nested-loop join

7. A nested-loop join with blocks of the inner relation paired with blocks of the outer relation is known as a ____ nested-loop join.

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

Answer: C) Block

Explanation:

A nested-loop join with blocks of the inner relation paired with blocks of the outer relation is known as a block nested-loop join.