View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables. You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORDERS table.
Which DELETE statements are valid? (Choose all that apply.)
A. DELETEFROM order_itemsWHERE order_id IN (SELECT order_idFROM ordersWHERE order_status in (0,1));
B. DELETE *FROM order_itemsWHERE order_id IN (SELECT order_idFROM ordersWHERE order_status IN (0,1));
C. DELETE FROM order_items iWHERE order_id = (SELECT order_id FROM orders o WHERE i. order_id = o. order_id AND order_status IN (0,1));
D. DELETEFROM (SELECT* FROM order_items i.orders o WHERE i.order_id = o.order_id AND order_status IN (0,1));
|
Download Printable PDF. VALID exam to help you PASS. |
 |