nerdexam
Oracle

1Z0-071 · Question #252

Examine the command to create the BOOKS table. The BOOK_ID value 101 does not exist in the table. Examine the SQL statement: Which statement is true?

The correct answer is A. It executes successfully and the row is inserted with a rule PUBLISHER_ID. See the full explanation below for the reasoning.

Question

Examine the command to create the BOOKS table. The BOOK_ID value 101 does not exist in the table. Examine the SQL statement:

Which statement is true?

Options

  • AIt executes successfully and the row is inserted with a rule PUBLISHER_ID.
  • BIt executes successfully only if NULL is explicitly specified in the INSERT statement.
  • CIt executes successfully only if the PUBLISHER_ID column name is added to the columns list in
  • DIt executes successfully only if the PUBLISHER_ID column name is added to the columns list and

How the community answered

(43 responses)
  • A
    72% (31)
  • B
    7% (3)
  • C
    16% (7)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice