nerdexam
Oracle

1Z0-882 · Question #74

You have issued the statement: CREATE TABLE numbers (number INT NOT NULL) ENGINE=MYISAM What is the result of issuing the following statement: INSERT INTO numbers VALUES (NULL)

The correct answer is D. The table is empty and an error message is returned. See the full explanation below for the reasoning.

Question

You have issued the statement:

CREATE TABLE numbers (number INT NOT NULL) ENGINE=MYISAM What is the result of issuing the following statement:

INSERT INTO numbers VALUES (NULL)

Options

  • AThe table contains the value 0
  • BThe table contains the value NULL
  • CThe table is empty, no error message is returned
  • DThe table is empty and an error message is returned

How the community answered

(21 responses)
  • A
    5% (1)
  • B
    5% (1)
  • C
    10% (2)
  • D
    81% (17)

Community Discussion

No community discussion yet for this question.

Full 1Z0-882 Practice