View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables. is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option. ORDER_ID - Which DELETE statement would execute successfully? 

Answer options:

A. DELETE orders o, order_items i WHERE o.order_id = i.order_id;
B. DELETE FROM orders WHERE (SELECT order_id FROM order_items);
C. DELETE orders WHERE order_total < 1000;
D. DELETE order_id FROM orders WHERE order_total < 1000;

C