Which database constraint prevents duplicate values in a specified column?

Options

  • A. CHECK
  • B. DEFAULT
  • C. UNIQUE
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. UNIQUE

Detailed Explanation

  • UNIQUE constraint: Ensures that duplicate non-NULL values are not allowed in the constrained column or column combination.
  • It helps prevent duplicate entries.
  • NULL handling for UNIQUE constraints can vary between DBMS products.