Examine the command to create the BOOKS table.
The BOOK_ID value 101 does not exist in the table.
Examine the SQL statement:
Which statement is true?
A. It executes successfully and the row is inserted with a rule PUBLISHER_ID.
B. It executes successfully only if NULL is explicitly specified in the INSERT statement.
C. It executes successfully only if the PUBLISHER_ID column name is added to the columns list in the INSERT statement.
D. It executes successfully only if the PUBLISHER_ID column name is added to the columns list and NULL is explicitly specified in the INSERT statement.
A