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.
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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 11 months agolucemqy
Most Recent 5 months, 1 week agometallers
6 months agozouve
10 months agokuff
11 months, 3 weeks agopmeyer
12 months agopmeyer
11 months, 2 weeks agoSkye21
1 year, 1 month agojr_C
1 year, 1 month agodexdinh91
1 year, 3 months agocadcadley
1 year, 3 months ago