Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 44 of 79

MySQL SQL Revision Tour — Question 12

Back to all questions
12
Question

Question 12

What is NOT NULL constraint ? What is DEFAULT constraint ?

Answer

The NOT NULL constraint is used in SQL to ensure that a column cannot contain NULL (i.e., empty) values.

A DEFAULT constraint is used in SQL to specify a default value for a column in a table. When the user does not enter a value for the column (having default value), automatically the defined default value is inserted in the field.