Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 9 of 50

Marks: +1, -0

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 two DELETE statements are valid (Choose two.)

DELETE * FROM order_items WHERE order_id IN (SELECT order_id) FROM orders WHERE order_status IN (0,1));
DELETE FROM (SELECT * FROM order_items I,orders o WHERE i.order_id = o.order_id AND order_status IN (0,1));
DELETE FROM order_items i WHERE order_id = (SELECT order_id FROM orders o WHERE i.order_id = o.order_id AND order_status IN (0,1));
DELETE FROM order_items WHERE order_id IN (SELECT order_id FROM orders WHERE orders_status in (0,1));

Validate

Go to Question:

Prev Question

Next Question