Exam 1z0-082 All QuestionsBrowse all questions from this exam
Question 137

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

    Correct Answer: A, D

    INTERVAL DAY TO SECOND columns support fractions of seconds, allowing for precise time measurements including sub-second values. INTERVAL YEAR TO MONTH columns are designed to handle intervals that span months and years, supporting monthly intervals over a range of years rather than being limited to a single year.

Discussion
nautil2Options: AD

True statements about intervals in Oracle Database 19c: A. True - INTERVAL DAY TO SECOND columns support fractions of seconds. D. True - INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years. False statements: B. False - The YEAR field in an INTERVAL YEAR TO MONTH column can be a negative value. C. False - The value in an INTERVAL DAY TO SECOND column cannot be copied into an INTERVAL YEAR TO MONTH column. E. False - INTERVAL YEAR TO MONTH columns can include monthly intervals spanning multiple years. F. False - INTERVAL YEAR TO MONTH columns do not support yearly intervals.

auwiaOptions: AF

Provided answer are wrong.

Oracle2020

I AGRRE AD

ivanadjOptions: AF

1z0-071 Question #: 292