Question

If you code a column list in an INSERT statement that includes a column that’s defined with a default value, you can insert the default value for that column by coding the ____________________ keyword in the VALUES clause of the INSERT statement.

Answer 1

Answer:

If you code a column list in an INSERT statement that includes a column that’s defined with a default value, you can insert the default value for that column by coding the DEFAULT keyword in the VALUES clause of the INSERT statement.

Explanation:

SQL permits insert the DEFAULT value on the columns when is required. Suppose the column has a NULL constraint(values on this column can not be set in null), then you can pass the default value.

For example:

INSERT INTO table(field1, field2, field3, field4) VALUES (10, DEFAULT, 20, DEFAULT)