Multiple choice technology databases

This table will have duplicate rows

  1. Volatile Table

  2. Global Temporary table

  3. MultiSet Table

  4. Permanent Table
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Teradata SQL, a Multiset table allows duplicate rows to be stored. Volatile tables are temporary session-specific tables. Global Temporary tables are also temporary. Permanent tables (default) typically enforce uniqueness constraints. The Multiset table type specifically permits duplicate rows, which is useful for certain data scenarios like logs or staging data.

Keep practicing — related questions