Multiple choice

The UNIQUE constraint requires that values must be

  1. Unique in the table

  2. Uniquely reference a primary key

  3. Unique in the row

  4. Unique in the column

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

The UNIQUE constraint ensures that all values in a specific column are different across all rows in the table. While this makes the values unique within that column across the table, the most precise description is that the values must be unique within that column.