When you add a row for which you have incomplete information to a SQL table, _____.
A) you must change the table structure so that all rows are marked as NOT NULL
B) you use the INSERT command and name the columns for which you are entering data
C) you use the INSERT command and enter a value of null for the columns without data
D) the DBMS will always reject the new row the first time you execute the command

Question

Quizplus · Accepted Answer

When adding a row with incomplete information, you can use the INSERT command and specify only the columns for which you have data, allowing the other columns to take their default values or remain NULL if allowed.

When You Add a Row for Which You Have Incomplete