ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

89 / 120

Question 89:

Examine the structure of the PROGRAMS table: 
image
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