Oracle Database Administration I — Question 93

Which two statements are true about INTERVAL data types? (Choose two.)

Answer options

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

Correct answer: A, F

Explanation

The correct answers are A and F because INTERVAL DAY TO SECOND columns indeed support fractions of seconds, and INTERVAL YEAR TO MONTH can represent yearly intervals. Options B and E are incorrect as the YEAR field does not have to be positive for INTERVAL YEAR TO MONTH, and it can represent intervals beyond a single year. Option C is incorrect as the data types are incompatible for direct copying, and option D is misleading as INTERVAL YEAR TO MONTH can span multiple years.