Oracle
1Z0-061 · Question #294
1Z0-061 Question #294: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #294. The question stem and answer options stay visible for context.
Question
Examine the structure of the PROMOS table: You want to generate a report showing promo names and their duration (number of days). If the PROMO_END_DATE has not been entered, the message 'ONGOING' should be displayed. Which queries give the correct output? (Choose all that apply.)
Exhibit
Options
- ASELECT promo_name, TO_CHAR(NVL(promo_end_date -promo_start_date, 'ONGOING')) FROM
- BSELECT promo_name, COALESCE(TO_CHAR(promo_end_date - promo_start_date),
- CSELECT promo_name, NVL(TO_CHAR(promo_end_date -promo_start_date), 'ONGOING') FROM
- DSELECT promo_name, DECODE(promo_end_date-promo_start_date, NULL, 'ONGOING',
- ESELECT promo_name, ecode(coalesce(promo_end_date, promo_start_date), null, 'ONGOING',
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.