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

Question

Exhibit

Options

• ASELECT promo_id. DECODE(NVL(promo_cost.O).promo_cost * 0.25. 100) "Discount" FROM
• BSELECT promo id. DECODE(promo_cost. 10000.
• CSELECT promo_id. DECODE(NULLIF(promo_cost. 10000). NULL. promo_cost*.25, *N/A')
• DSELECT promo_id. DECODE(promo_cost. >10000. 'High'. <10000. 'Low') "Range"FROM

• A
  84% (31)
• C
  11% (4)
• D
  5% (2)

Explanation

Note: there are some syntax issues in this question.

No community discussion yet for this question.