Multiple choice technology databases

which table supports duplicate rows insertion?

  1. Set

  2. Multiset

  3. Volatile

  4. Temporary
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A Multiset table in Teradata allows duplicate rows to be inserted, unlike a Set table which enforces uniqueness. Volatile and Temporary tables are table types related to scope/lifetime, not duplicate handling. The Multiset option is specifically designed to permit duplicate records.

Keep practicing — related questions