Oracle
1Z0-047 · Question #250
View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column has the PRIMARY KEY constraint and CUSTOMER_ID has the NOT NULL constraint. Evaluate the following statement…
The correct answer is C. It would not execute successfully because the ORDER_TOTAL column is not specified in the SELECT. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column has the PRIMARY KEY constraint and CUSTOMER_ID has the NOT NULL constraint. Evaluate the following statement:
INSERT INTO (SELECT order_id.order_date.customer_id FROM ORDERS WHERE order_total = 1000 WITH CHECK OPTION) VALUES (13, SYSDATE, 101); What would be the outcome of the above INSERT statement?
Exhibit
Options
- AIt would execute successfully and the new row would be inserted into a new temporary table created by
- BIt would execute successfully and the ORDER_TOTAL column would have the value 1000 inserted
- CIt would not execute successfully because the ORDER_TOTAL column is not specified in the SELECT
- DIt would not execute successfully because all the columns from the ORDERS table should have been
How the community answered
(23 responses)- A4% (1)
- B13% (3)
- C78% (18)
- D4% (1)
Community Discussion
No community discussion yet for this question.