Multiple choice technology databases

To use Global temporary tables in a compound statement you require which type of tablespace to be present

  1. User temporary

  2. Large

  3. System

  4. Regular

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In DB2, declared global temporary tables (DGTTs) require a USER TEMPORARY tablespace to be defined in the database so that the temporary table's instantiated rows can be stored.