Oracle
1Z0-047 · Question #70
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?
The correct answer is A. +25-00 , +54-02, +00 11:12:10.123457. See the full explanation below for the reasoning.
Question
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?
Options
- 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
How the community answered
(49 responses)- A80% (39)
- B6% (3)
- C12% (6)
- D2% (1)
Community Discussion
No community discussion yet for this question.