Which three DELETE statements execute successfully?

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?
A. DELETE order_id FROM orders WHERE order_total < 1000;
B. DELETE FROM orders WHERE order_total < 1000;
C. DELETE orders WHERE order_total < 1000;
D. DELETE * FROM orders WHERE order_total < 1000;
E. DELETE FROM orders;

Download Printable PDF. VALID exam to help you PASS.

2 thoughts on “Which three DELETE statements execute successfully?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.