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. 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

Introduction to SQL

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

(22 responses)

A
82% (18)
B
9% (2)
C
5% (1)
D
5% (1)

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

Topics

#INTERVAL literal#YEAR TO MONTH#HOUR TO SECOND#interval formatting

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice