Home »
MCQs »
DBMS MCQs »
DBMS Nested-Loop Join Algorithm MCQs
As soon as the first match is found for each outer relation tuple in a/an _____, the inner loop terminates
14. As soon as the first match is found for each outer relation tuple in a/an _____, the inner loop terminates.
- Equijoin
- Natural join
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
As soon as the first match is found for each outer relation tuple in an equijoin or natural join, the inner loop terminates.