Oracle
1Z0-071 · Question #325
Which two statements are true about INTERVAL data types? (Choose two.)
The correct answer is B. INTERVAL DAY TO SECOND columns support fractions of seconds. E. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years. See the full explanation below for the reasoning.
Question
Which two statements are true about INTERVAL data types? (Choose two.)
Options
- AThe YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.
- BINTERVAL DAY TO SECOND columns support fractions of seconds.
- CINTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.
- DINTERVAL YEAR TO MONTH columns support yearly intervals.
- EINTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.
- FThe value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR
How the community answered
(30 responses)- B77% (23)
- C3% (1)
- D13% (4)
- F7% (2)
Community Discussion
No community discussion yet for this question.