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

For each tuple in the inner relationship s, the ____-loop join reads it once for each tuple in the outer relationship r

12. For each tuple in the inner relationship s, the ____-loop join reads it once for each tuple in the outer relationship r.

1. Join
2. Nested
3. Block
4. None

Answer: B) Nested

Explanation:

For each tuple in the inner relationship s, the nested-loop join reads it once for each tuple in the outer relationship r.