Question

Point out the correct statement.

(a) CHECK constraints enforce domain integrity

(b) UNIQUE constraints enforce the uniqueness of the values in a set of columns

(c) In a UNIQUE constraint, no two rows in the table can have the same value for the columns

(d) All of the mentioned

The question was posed to me in my homework.

I'm obligated to ask this question of Constraints topic in portion Manipulating Data with Select of SQL Server

Answer 1

The correct option is (d) All of the mentioned

To explain: Constraints let you define the way the Database Engine automatically enforces the integrity of a database.