Oracle
1Z0-071 · Question #359
The ORDERS table has a primary key constraint on the ORDER_ID column. The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table. The…
The correct answer is A. DELETE order_id FROM orders WHERE order_total < 1000; C. DELETE orders WHERE order_total < 1000. See the full explanation below for the reasoning.
Question
The ORDERS table has a primary key constraint on the ORDER_ID column. The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table. The constraint is defined with ON DELETE CASCADE. There are rows in the ORDERS table with an ORDER_TOTAL of less than 1000. Which three DELETE statements execute successfully?
Options
- ADELETE order_id FROM orders WHERE order_total < 1000;
- BDELETE FROM orders WHERE order_total < 1000;
- CDELETE orders WHERE order_total < 1000;
- DDELETE * FROM orders WHERE order_total < 1000;
- EDELETE FROM orders;
How the community answered
(25 responses)- A80% (20)
- B4% (1)
- D12% (3)
- E4% (1)
Community Discussion
No community discussion yet for this question.