Oracle Exam 1Z0-082 Topic 18 Question 95 Discussion

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

Question #: 95
Topic #: 18

[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 Yvette at Jun 19, 2024, 02:51 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Paul

11 months ago

This exam question is making my head spin. I think I'll just go with the flow and say that all the options are true. That way, I'm guaranteed to get at least a few answers right!

upvoted 0 times

...

Octavio

11 months ago

I'm going to have to agree with Doug on C. Interval day to second columns are the way to go if you need that extra precision. Who needs years and months anyway? Just give me seconds!

upvoted 0 times

Tashia

10 months ago

Agreed, interval day to second columns are the way to go for that extra precision.

upvoted 0 times

...

Tamar

10 months ago

I think interval day to second columns are more precise as well.

upvoted 0 times

...

Paris

10 months ago

I prefer interval day to second columns too. Seconds are all I need!

upvoted 0 times

...

Kerry

10 months ago

Agreed, interval day to second columns are the way to go for that extra precision.

upvoted 0 times

...

Raina

11 months ago

I think interval day to second columns are more precise as well.

upvoted 0 times

...

Sharita

11 months ago

I prefer interval day to second columns too. Seconds are all I need!

upvoted 0 times

...

Rory

11 months ago

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

upvoted 0 times

...

Lyda

11 months ago

I'm not sure about statement D and E, can someone explain why they are true?

upvoted 0 times

...

Audra

11 months ago

I agree with Elfriede, interval day to second columns do support fractions of seconds.

upvoted 0 times

...

Lottie

12 months ago

D and E both sound plausible to me. Interval year to month columns only support monthly intervals, and those intervals are limited to a single year or a range of years.

upvoted 0 times

...

Krissy

12 months ago

Hmm, I'm not sure about B. Can you really copy the value from an interval day to second column into an interval year to month column? Seems like that might cause some data loss.

upvoted 0 times