MCQ IN COMPUTER SCIENCE & ENGINEERING

Detailed explanation-1: -The CHECK constraint is used mainly to enforce the domain integrity by limiting the inserted values to the ones that follow the defined values, range or format rules.

Detailed explanation-2: -The CHECK constraint is used to limit the value range that can be placed in a column. If you define a CHECK constraint on a column it will allow only certain values for this column. If you define a CHECK constraint on a table it can limit the values in certain columns based on values in other columns in the row.

Detailed explanation-3: -CHECK constraints enforce domain integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical (Boolean) expression that returns TRUE or FALSE based on the logical operators.

Detailed explanation-4: -Integrity Constraints are the protocols that a table’s data columns must follow. These are used to restrict the types of information that can be entered into a table. This means that the data in the database is accurate and reliable. You may apply integrity Constraints at the column or table level.

Detailed explanation-5: -A check constraint, applied at the time of table creation, enforces domain integrity by limiting the set of values that can be assigned to a column.