Exam 1z0-061 topic 3 question 19 discussion

Actual exam question from Oracle's 1z0-061

Question #: 19
Topic #: 3

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;

Show Suggested Answer

Suggested Answer: AB 🗳️
Note: there are some syntax issues in this question.

by winston at May 26, 2023, 2:39 p.m.

Submit Cancel

1 year, 8 months ago

question is ambigous

upvoted 1 times

...

Most Voted

Loading ...