Question 89:
Examine the structure of the PROGRAMS table:
Which two SQL statements would execute successfully?
Answer options:
A. SELECT NVL (ADD_MONTHS (END_DATE,1) SYSDATE) FROM programs; B. SELECT TO_DATE (NVL (SYSDATE-END_DATE, SYSDATE)) FROM programs; C. SELECT NVL (MONTHS_BETWEEN (start_date, end_date), "˜Ongoing`) FROM programs; D. SELECT NVL (TO_CHAR (MONTHS_BETWEEN (start-date, end_date)), "˜Ongoing`) FROM programs