Microsoft Exam Questions

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