Evaluate the following query:
SELECT INTERVAL ‘300’ MONTH,
INTERVAL ’54-2′ YEAR TO MONTH,
INTERVAL ’11:12:10.1234567′ HOUR TO SECOND
FROM dual;
What is the correct output of the above query?
A.
+25-00 , +54-02, +00 11:12:10.123457
B.
+00-300, +54-02, +00 11:12:10.123457
C.
+25-00 , +00-650, +00 11:12:10.123457
D.
+00-300 , +00-650, +00 11:12:10.123457
Explanation:
Datetime Data Types
You can use several datetime data types:
INTERVAL YEAR TO MONTH
Stored as an interval of years and months
INTERVAL DAY TO SECOND
Stored as an interval of days, hours, minutes, and seconds