Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 12 of 79

Table Creation and Data Manipulation Commands — Question 6

Back to all questions
6
Question

Question 6

When a column's value is skipped in an INSERT command, which value is inserted in the database ?

Answer

The columns that are not listed in the INSERT command will have their default value, if it is defined for them, otherwise, NULL value. If any other column (that does not have a default value and is defined NOT NULL) is skipped or omitted, an error message is generated and the row is not added.