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

© examsnet.com

Question : 5 of 50

Marks: +1, -0

Examine the structure of the PROGRAMS table:

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:

Advertisements