Multiple choice technology databases

A declared temporary table is used for which of the following purposes?

  1. Backup purposes

  2. Storing intermediate results

  3. Staging area for load operations

  4. Sharing result data sets between applications

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

Declared temporary tables (DGTTs) are private to a session and are primarily used to store intermediate query results during complex processing, automatically disappearing when the session terminates.