Oracle
1Z0-071 · Question #359
1Z0-071 Question #359: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #359. The question stem and answer options stay visible for context.
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;
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.