Oracle
1Z0-082 · Question #157
Which two statements are true about interval data types?
The correct answer is A. INTERVAL year TO month columns support yearly intervals. C. INTERVAL day to second columns support fractions of seconds. See the full explanation below for the reasoning.
SQL and PL/SQL
Question
Which two statements are true about interval data types?
Options
- AINTERVAL year TO month columns support yearly intervals.
- BThe value in an interval day to SECOND column can be copied into an interval year to month
- CINTERVAL day to second columns support fractions of seconds.
- DINTERVAL year to month columns only support monthly Intervals within a single year.
- EINTERVAL year to month columns only support monthly intervals within a range of years.
- FThe year field in an interval year to month column must be a positive value.
How the community answered
(28 responses)- A79% (22)
- B11% (3)
- D4% (1)
- E7% (2)
Topics
#INTERVAL data type#INTERVAL YEAR TO MONTH#INTERVAL DAY TO SECOND#date arithmetic
Community Discussion
No community discussion yet for this question.