What Will Happen If You Try to Use the INSERT

question 126

Multiple Choice

What will happen if you try to use the INSERT command to insert a NULL value into a column that has been assigned a PRIMARY KEY constraint? ​

• A) ​The command will execute because a PRIMARY KEY value can be NULL.
• B) ​An error message is returned and the row is not added to the table.
• C) ​The command will execute because only a UNIQUE constraint forbids NULL values.
• D) ​An error message is returned but the unaffected portion of the row is added to the table.

---

Definitions:

Partial Sum

The sum of a specified sequence of terms up to a certain number in the sequence.

Negative Exponent

Indicates that the base of the exponent should be reciprocated and the exponent made positive.

Arithmetic Sequence

A series where each number following the initial one is derived by adding a fixed value to the term before it.

Nth Term

The general term of a sequence, represented as a function of its position, n, in the sequence.