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

Sol40:

The correct statement is d) All of the mentioned.

CHECK constraints are used to enforce domain integrity, which means that the values entered into a column or set of columns must be of a certain data type or meet certain conditions.

UNIQUE constraints are used to ensure that the values in a set of columns are unique, which means that no two rows in the table can have the same value for those columns.

Therefore, both statement a) and c) are correct, and statement b) is also correct but does not provide the complete picture.