Which two SQL statements would execute successfully?

See the structure of the PROGRAMS table: Which two SQL statements would execute
successfully? (Choose two.)

See the structure of the PROGRAMS table: Which two SQL statements would execute
successfully? (Choose two.)

A.
SELECT NVL(MONTHS_BETWEEN(start_date,end_date),’Ongoing’) FROM programs;

B.
SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start_date,end_date)),’Ongoing’) FROM
programs;

C.
SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE)) FROM programs;

D.
SELECT NVL(ADD_MONTHS(END_DATE,1),SYSDATE) FROM programs;



Leave a Reply 0

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