Explanation:
The given query is using an interval literal with a value of '100' and a unit of 'MONTH'. When using the interval literal syntax, the specified value represents the number of intervals of the given unit.
In this case, the query is requesting an interval of 100 months. Since there are 12 months in a year, the interval '100' months is equivalent to 8 years and 4 months.
The output format for intervals in Oracle is '+YY-MM', where YY represents the number of years and MM represents the number of months.
Therefore, the output will be '+08-04', indicating an interval of 8 years and 4 months.
The correct answer is D. +08-04.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
CyberP
Highly Voted 7 months, 2 weeks agolucemqy
Most Recent 1 month, 3 weeks agometallers
2 months, 2 weeks agozouve
6 months, 2 weeks agokuff
8 months, 1 week agopmeyer
8 months, 2 weeks agopmeyer
8 months agoSkye21
10 months, 1 week agojr_C
10 months agodexdinh91
1 year agocadcadley
1 year ago