Home »
MCQs »
DBMS MCQs »
DBMS Nested-Loop Join Algorithm MCQs
Every tuple from one block is paired with every tuple from the other block in the ___ to produce all pairs of tuples
9. Every tuple from one block is paired with every tuple from the other block in the ___ to produce all pairs of tuples.
- Block nested-loop
- Nested-loop
- Join-loop
- None
Answer: A) Block nested-loop
Explanation:
Every tuple from one block is paired with every tuple from the other block in the block nested-loop to produce all pairs of tuples.