You execute the following statement: INSERT INTO Road VALUES (1234, 36) What is the result?

Last Updated on August 18, 2021 by Admin 2

You have the following table definition:

CREATE TABLE Road
(RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)

The Road table contains the following data:

98-364 Part 01 Q14 006
98-364 Part 01 Q14 006

You execute the following statement:
INSERT INTO Road VALUES (1234, 36)

What is the result?

  • an error stating that NULL values are not allowed
  • a new row in the table
  • an error stating that duplicate IDs are not allowed
  • a syntax error
5 1 vote
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments