What is the correct output of the above query?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *