Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 173

Which two statements are true about INTERVAL data types?

INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

INTERVAL DAY TO SECOND columns support fractions of seconds.

INTERVAL YEAR TO MONTH columns support yearly intervals.

The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

Correct Answer: B, C

INTERVAL data types allow for precise representation of periods of time. INTERVAL YEAR TO MONTH columns support intervals that can span multiple years, allowing you to easily represent differences in years and months. INTERVAL DAY TO SECOND columns include fractions of seconds, providing detailed precision within a day. These aspects make B and C the correct answers.

Discussion

McromeoOptions: BC

BC is correct

musafirOptions: BC

https://www.examtopics.com/discussions/oracle/view/10416-exam-1z0-071-topic-1-question-292-discussion/