Oracle
1Z0-074 · Question #87
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
(15 responses)- A80% (12)
- B7% (1)
- D13% (2)
Community Discussion
No community discussion yet for this question.