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

Nesting-loop joins are very ____ due to the fact that each pair of tuples in the two given relations must be computed and examined separately

5. Nesting-loop joins are very ____ due to the fact that each pair of tuples in the two given relations must be computed and examined separately.

1. Cheap
2. Expensive
3. Few
4. None

Answer: B) Expensive

Explanation:

Nesting-loop joins are very expensive due to the fact that each pair of tuples in the two given relations must be computed and examined separately.