See the structure of the PROGRAMS table:Which two SQL statements would execute successfully? (Choose two.)
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;
See the structure of the PROGRAMS table:Which two SQL statements would execute successfully? (Choose two.)
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am