Oracle
1Z0-061 · Question #161
1Z0-061 Question #161: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #161. The question stem and answer options stay visible for context.
Question
See the Exhibit and examine the structure of the PROMOSTIONS table: Which SQL statements are valid? (Choose all that apply.)
Exhibit
Options
- ASELECT promo_id, DECODE(NVL(promo_cost, 0), promo_cost,
- BSELECT promo_id, DECODE(promo_cost, 10000,
- CSELECT promo_id, DECODE(NULLIF(promo_cost, 10000),
- DSELECT promo_id, DECODE(promo_cost, >10000, 'High',
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.