Oracle
1Z0-061 · Question #111
1Z0-061 Question #111: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #111. The question stem and answer options stay visible for context.
Question
See the structure of the PROGRAMS table: Which two SQL statements would execute successfully? (Choose two.)
Options
- ASELECT NVL(ADD_MONTHS(END_DATE, 1), SYSDATE)
- BSELECT TO_DATE(NVL(SYSDATE-END_DATE, SYSDATE))
- CSELECT NVL(MONTHS_BETWEEN(start_date, end_date), 'Ongoing')
- DSELECT NVL(TO_CHAR(MONTHS_BETWEEN(start_date, end_date)), 'Ongoing') FROM
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.