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’;