Learn about the INTERVAL data types in Oracle Database 12c SQL. Discover the capabilities and limitations of INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND columns.
Table of Contents
Question
Which two statements are true about INTERVAL data types?
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.
Answer
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.
Explanation
INTERVAL YEAR TO MONTH columns store a period of time using the YEAR and MONTH datefields. They support monthly intervals within a range of years, not just a single year. The YEAR field can be negative.
INTERVAL DAY TO SECOND columns store a period of time using the DAY and SECOND datefields. They support fractions of seconds.
The value in an INTERVAL DAY TO SECOND column cannot be copied into an INTERVAL YEAR TO MONTH column due to their different datefields.
Oracle Database 12c SQL 1z0-071 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Oracle Database 12c SQL 1z0-071 exam and earn Oracle Database 12c SQL 1z0-071 certification.