View the Exhibit and examine the data in the PROMOTIONS table. You need to display all
promo categories that do not have ‘discount’ in their subcategory. Which two SQL
statements give the required result? (Choose two.)
A.
SELECT promo_category FROM promotions MINUS SELECT promo_category FROM
promotions WHERE promo_subcategory = ‘discount’;
B.
SELECT promo_category FROM promotions INTERSECT SELECT promo_category
FROM promotions WHERE promo_subcategory = ‘discount’;
C.
SELECT promo_category FROM promotions MINUS SELECT promo_category FROM
promotions WHERE promo_subcategory <> ‘discount’;
D.
SELECT promo_category FROM promotions INTERSECT SELECT promo_category
FROM promotions WHERE promo_subcategory <> ‘discount’;
Explanation: