Which SQL statements are valid?

View the Exhibit and examine the structure of the PROMOTIONS table. Which SQL
statements are valid? (Choose all that apply.)

A.
SELECT promo_id. DECODE(NULLIF(promo_cost. 10000). NULL. promo_cost*.25,
*N/A’) “Catcost” FROM promotions;

B.
SELECT promo id. DECODE(promo_cost. 10000. DECODE(promo_category. ‘Gl\
promo_cost * 25. NULL). NULL) “Catcost” FROM promotions;

C.
SELECT promo_id. DECODE(NVL(promo_cost.O).promo_cost * 0.25. 100) “Discount”
FROM promotions;

D.
SELECT promo_id. DECODE(promo_cost. >10000. ‘High’. <10000. ‘Low’)
“Range”FROM promotions;