What is the result?

Posted by: Pdfprep Category: 98-364 Tags: , ,

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

Answer: B

Leave a Reply

Your email address will not be published.