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.)

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.)

Accepted Answer

B. SELECT promo_name, COALESCE(TO_CHAR(promo_end_date - promo_start_date), C. SELECT promo_name, NVL(TO_CHAR(promo_end_date -promo_start_date), 'ONGOING') FROM D. SELECT promo_name, DECODE(promo_end_date-promo_start_date, NULL, 'ONGOING',

Answer

A. SELECT promo_name, TO_CHAR(NVL(promo_end_date -promo_start_date, 'ONGOING')) FROM

Answer

E. SELECT promo_name, ecode(coalesce(promo_end_date, promo_start_date), null, 'ONGOING',

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'…

Question

Exhibit

Options

How the community answered

Community Discussion