Home »
MCQs »
DBMS MCQs »
DBMS Double-Pipelined Join Algorithm MCQs
The ____ is a blocking operation that must be completed before it can output any results. Its input must be fetched completely and its output must be partitioned
1. The ____ is a blocking operation that must be completed before it can output any results. Its input must be fetched completely and its output must be partitioned.
- Join
- Partition Join
- Nested-Join
- Hash-Join
Answer: D) Hash-Join
Explanation:
The hash-join is a blocking operation that must be completed before it can output any results. Its input must be fetched completely and its output must be partitioned.