ocp-047-96(疑问）

 
96. View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS 
tables.ORDER_ID is the primary key in the ORDERS table. It is a lso the foreign 
key in the ORDER_ITEMS table where in it is created with the ON  DELETE CASCADE 
option. Which DELETE statement would execute successfully? 
A. DELETE order_id FROM orders WHERE order_total < 1000; 
B. DELETE orders WHERE order_total < 1000; 
C. DELETE FROM orders WHERE (SELECT order_id FROM order_items); 

D.DELETE orders o, order_items I WHERE o.order_id = i.order_id; 

Answer: B