Regarding INTERVAL data types in Oracle Database 12c:
A. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years. This is true. The INTERVAL YEAR TO MONTH data type stores a period of time using years and months.
E. INTERVAL DAY TO SECOND columns support fractions of seconds. This is true. The INTERVAL DAY TO SECOND data type can store days, hours, minutes, seconds, and fractional seconds.
Options B, C, D, and F are incorrect:
B is incorrect because data types between INTERVAL DAY TO SECOND and INTERVAL YEAR TO MONTH are not compatible.
C is incorrect as it incorrectly limits INTERVAL YEAR TO MONTH to a single year.
D is incorrect; the YEAR field can be negative to represent a past interval.
F is incorrect as INTERVAL YEAR TO MONTH supports intervals that can span multiple years, not just annual increments.
[Reference: Oracle Database SQL Language Reference, 12c Release 1 (12.1), , ]
Submit