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

We can replace the file scans with highly efficient index lookups if an index is present on the ___ attribute of the inner loop

18. We can replace the file scans with highly efficient index lookups if an index is present on the ___ attribute of the inner loop.

1. Log
2. Join
3. Array
4. Stack

Answer: B) Join

Explanation:

We can replace the file scans with highly efficient index lookups if an index is present on the join attribute of the inner loop.