Home » MCQs » SQL MCQs » SQL Constraints Clause MCQs

What is TRUE about DEFAULT constraint?

12. What is TRUE about DEFAULT constraint?

1. The value will first be checked for certain conditions before inserting it into the column when a DEFAULT constraint applies to a column in the table.
2. In the event of a DEFAULT constraint being applied to a table's column without a user specifying the value to be inserted when that constraint was applied, the default value that was specified when the constraint was applied will be put into that column.
3. An index can be created on the table using the DEFAULT constraint.
4. None of the above

Answer: B) In the event of a DEFAULT constraint being applied to a table's column without a user specifying the value to be inserted when that constraint was applied, the default value that was specified when the constraint was applied will be put into that column

Explanation:

In the event of a default constraint is applied to a table's column without a user specifying the value to be inserted when that constraint was applied, the default value that was specified when the constraint was applied will be put into that column.