nerdexam
Microsoft

98-364 · Question #128

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…

The correct answer is B. a new row in the table. See the full explanation below for the reasoning.

Question

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?

Options

  • Aan error stating that NULL values are not allowed
  • Ba new row in the table
  • Can error stating that duplicate IDs are not allowed
  • Da syntax error

How the community answered

(20 responses)
  • A
    5% (1)
  • B
    80% (16)
  • C
    10% (2)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice