Test Index

Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 5

Total: 50

Which two SQL statements would execute successfully?

SELECT NVL(ADD_MONTHS(END_DATE,1)SYSDATE) FROM programs;
SELECT TO_DATE(NVL(SYSDATE-END_DATE,SYSDATE)) FROM programs;
SELECT NVL(MONTHS_BETWEEN(start_date,end_date),‘Ongoing’) FROM programs;
SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start-date,end_date)),‘Ongoing’) FROM programs;

Go to Question:

Prev Question

Next Question