Multiple choice technology databases

Intermediate results of the user query is materialized at

  1. Temporary Space

  2. Spool Space

  3. Permanent Space

  4. Any of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Intermediate query results are stored in spool space during query execution. Spool space provides the workspace needed for sorting, joining, and other operations that generate intermediate result sets. This workspace is released after the query completes.

Keep practicing — related questions