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

Question : 27 of 50

Marks: +1, -0

View the exhibit and examine the description of SALES and PROMOTIONS tables.

You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has either blowout sale or everyday low priceas values.
Which three DELETE statements are valid? (Choose three.)

DELETE FROM sales WHERE promo_id = (SELECT promo_id FROM promo_name = ‘blowout sale’) AND promo_id = (SELECT promo_id FROM promotions WHERE promo_name = ‘everyday low price’) FROM promotions WHERE promo_name = ‘everyday low price’);
DELETE FROM sales WHERE promo_id = (SELECT promo_id FROM promotions WHERE promo_name = ‘blowout sale’) OR promo_id = (SELECT promo_id FROM promotions WHERE promo_name = ‘everyday low price’)
DELETE FROM sales WHERE promo_id = (SELECT promo_id FROM promotions WHERE promo_name = ‘blowout sale’) OR promo_name = ‘everyday low price’);
DELETE FROM sales WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_name IN = ‘blowout sale’,‘everyday low price’));

Validate

Go to Question:

Prev Question

Next Question