Question Details

Detailed explanation and options for the selected question.

What happens if you try to insert a duplicate value in a column with a UNIQUE constraint?

A. The insertion fails
B. The duplicate value is allowed
C. The database removes the duplicate
D. The duplicate value is ignored

Explanation:

Inserting a duplicate value in a column with a UNIQUE constraint fails because the constraint enforces distinct values.