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(NVL(promo_cost.O).promo_cost * 0.25. 100) "Discount"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(NULLIF(promo_cost. 10000). NULL. promo_cost*.25, *N/A’) "Catcost"FROM promotions;
D. SELECT promo_id. DECODE(promo_cost. >10000. ‘High’. <10000. ‘Low’) "Range"FROM promotions;

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.