Multiple choice technology databases

Which of the following tables could be used for a user who wants to create a small Temporary table with Spool Space?

  1. Derived Table

  2. Volatile Table

  3. Global Temporary Table

  4. None
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

Derived tables exist only for the duration of a single query and use spool space. Volatile tables persist throughout the user session but also use spool space rather than permanent disk space. Global Temporary Tables, by contrast, use permanent disk space and are materialized.

Keep practicing — related questions