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;