Multiple choice technology databases

Which of the following types of statements can use a temporary tablespace?

  1. An index creation

  2. SQL statements with a GROUP BY clause

  3. A hash join operation

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Temporary tablespaces store temporary data for operations like sorting, hashing, and index builds. All three listed operations (index creation, GROUP BY, and hash joins) generate intermediate results that may require temporary storage.

Keep practicing — related questions