Which of the following will allow a user to enter a NULL value using the INSERT command?
A) Omit the column from the column list in the INSERT INTO clause.
B) Substitute two single quotation marks in the VALUES clause in the position of the column that is to be assigned the NULL value.
C) Use the NULL keyword.
D) all of the above

Question

Which of the following will allow a user to enter a NULL value using the INSERT command?​
A) ​Omit the column from the column list in the INSERT INTO clause.
B) ​Substitute two single quotation marks in the VALUES clause in the position of the column that is to be assigned the NULL value.
C) ​Use the NULL keyword.
D) ​all of the above

Quizplus · Accepted Answer

A) Omitting the column from the column list in the INSERT INTO clause will insert a NULL value for that column.
B) Substituting two single quotation marks in the VALUES clause will insert an empty string, not a NULL value.
C) Using the NULL keyword will insert a NULL value.

Which of the Following Will Allow a User to Enter