Oracle Database SQL — Question 146

Which two statements are true about INTERVAL data types?

Answer options

• A. INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.
• B. INTERVAL DAY TO SECOND columns support fractions of seconds.
• C. INTERVAL YEAR TO MONTH columns support yearly intervals.
• D. The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.
• E. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.
• F. The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

Correct answer: B, C

Explanation

Option B is correct because INTERVAL DAY TO SECOND columns can indeed represent fractions of seconds, which is a key feature. Option C is also correct as INTERVAL YEAR TO MONTH columns are designed to support yearly intervals. The other options are incorrect as they either misrepresent the capabilities of INTERVAL data types or impose incorrect limitations.