The IT Certification Resource Center

Featured Deal

Get CompTIA, Cisco, and Microsoft training courses free for a week.
Learn More ❯

Exam 1Z0-061 — Oracle Database 12c: SQL Fundamentals

Question 3:

Evaluate the following SQL query;

SELECT TRUNC(LAST_DAY(TO_DATE('07-APR-15', 'DD-MON-YY')) + 2, 'MM')
FROM   dual;

What would be the result of executing this query?

A. 01-APR-15
B. 30-APR-15
C. 31-MAY-15
D. 01-MAY-15
E. 02-MAY-15