Question

11 multiple choice 1 point what is the purpose of the not null constraint when creating a table in sql? it specifies that the column cannot contain null values. it enforces referential integrity between tables. it ensures that the column will have a unique value for each row. it sets a default value for the column when no value is specified.

Explanation:

The NOT NULL constraint in SQL is a column - level constraint. Its main function is to restrict the values that can be inserted into a column. When a column has the NOT NULL constraint, it means that for every row in the table, that column must have a non - NULL value. Referential integrity is enforced by foreign key constraints. A unique value for each row is ensured by the UNIQUE constraint (or PRIMARY KEY which also implies uniqueness). Setting a default value is done using the DEFAULT keyword.

Answer:

It specifies that the column cannot contain NULL values.