Multiple choice technology databases

Which Index ensures uniqueness in a table?

  1. UPI

  2. NUPI

  3. NUSI

  4. USI

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

UPI (Unique Primary Index) enforces uniqueness on the index column(s) in Teradata, ensuring no two rows have the same index value. NUPI allows duplicates, while NUSI and USI are secondary indexes.