Oracle Exam 1Z0-082 Topic 4 Question 86 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 86
Topic #: 4

[All 1Z0-082 Questions]

Which two statements are true about interval data types?

AINTERVAL year TO month columns support yearly intervals.

BThe value in an interval day to SECOND column can be copied into an interval year to month column.

CINTERVAL day to second columns support fractions of seconds.

DINTERVAL year to month columns only support monthly Intervals within a single year.

EINTERVAL year to month columns only support monthly intervals within a range of years.

FThe year field in an interval year to month column must be a positive value.

Show Suggested Answer

Suggested Answer: A, C

by Hillary at Feb 12, 2024, 05:03 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jean

6 months ago

I'm not so sure about statement E. I think it should be false as interval year to month columns support monthly intervals within a single year.

upvoted 0 times

...

Oretha

6 months ago

I believe statement D is also true. Interval year to month columns only support monthly intervals within a single year.

upvoted 0 times

...

Kris

7 months ago

I agree with you, Pamella. Interval day to second columns do support fractions of seconds.

upvoted 0 times

...

Pamella

7 months ago

I think statement A and C are true.

upvoted 0 times

...

Nohemi

7 months ago

That makes sense. So statement E is true because it specifies a range of years for monthly intervals.

upvoted 0 times

...

Lamonica

7 months ago

I believe statement E is true because INTERVAL year to month columns only support monthly intervals within a range of years, not just within a single year.

upvoted 0 times

...

Shantell

7 months ago

I'm not sure about statement E. Can you explain why you think it is true?

upvoted 0 times

...

Nohemi

7 months ago

I agree with Lamonica. Interval day to second columns do support fractions of seconds.

upvoted 0 times

...

Lamonica

7 months ago

I think statement A and C are true.

upvoted 0 times

...