Multiple choice technology databases

Which type of table provides the DDL, but does not share the data

  1. Global Temporary

  2. Permanent

  3. Derived

  4. Volatile

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

In Teradata, a Global Temporary Table (GTT) stores its definition (DDL) in the data dictionary, which is shared by all users. However, the data inserted into the table is materialized in temp space and is private to the session, meaning users do not share data.