What is the result?

You have the following table definition:

CREATE TABLE Road

(RoadID INTEGER NOT NULL,

Distance INTEGER NOT NULL)

The Road table contains the following data:

You execute the following statement:

INSERT INTO Road VALUES (1234, 36)

What is the result?
A . an error stating that NULL values are not allowed
B . a new row in the table
C . an error stating that duplicate IDs are not allowed
D . a syntax error

View Answer

Answer: B