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