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 10 months, 1 week agolucemqy
Most Recent 4 months, 2 weeks agometallers
5 months, 1 week agozouve
9 months, 1 week agokuff
11 months agopmeyer
11 months, 1 week agopmeyer
10 months, 3 weeks agoSkye21
1 year agojr_C
1 year agodexdinh91
1 year, 2 months agocadcadley
1 year, 2 months ago