When you use the INTERVAL literal for months, the result is displayed in years and months if the total number of months exceeds 12.
In the query given:
SELECT INTERVAL '100' MONTH DURATION FROM DUAL;
the output will display the interval of 100 months converted to years and the remaining months. 100 months is equal to 8 years and 4 months. Hence, the correct answer is:
DURATION +08-04
[Reference: Oracle Database SQL Language Reference 12c, Datetime and Interval Arithmetic - Datetime and Interval Types, ]
1z0-071 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"