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

It is efficient to use the inner relation s as the outer relation if neither of the given relations r or s completely fit into the ____

13. It is efficient to use the inner relation s as the outer relation if neither of the given relations r or s completely fit into the ____.

1. Block
2. Size
3. Memory
4. Storage

Answer: C) Memory

Explanation:

It is efficient to use the inner relation s as the outer relation if neither of the given relations r or s completely fit into the memory.