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)- A72% (31)
- B7% (3)
- C16% (7)
- D5% (2)
Community Discussion
No community discussion yet for this question.