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.
OOps! You are currently offline.