Oracle Exam 1Z0-071 Topic 4 Question 77 Discussion

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

Question #: 77
Topic #: 4

[All 1Z0-071 Questions]

You have been asked to create a table for a banking application.

One of the columns must meet three requirements:

1: Be stored in a format supporting date arithmetic without using conversion functions

2: Store a loan period of up to 10 years

3: Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

ATIMESTAMP WITH TIMEZONE

BTIMESTAMP

CTIMESTAMP WITH LOCAL TIMEZONE

DINTERVAL YEAR TO MONTH

EINTERVAL DAY TO SECOND

Show Suggested Answer

Suggested Answer: D, E

by Elvera at Jul 27, 2023, 06:24 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Lea

14 days ago

I see both points, but I would go with E) INTERVAL DAY TO SECOND as it seems to meet all three requirements for the column in the banking application.

upvoted 0 times

...

Alesia

16 days ago

I disagree, I believe the correct answer is E) INTERVAL DAY TO SECOND as it can store the loan period and calculate interest based on days.

upvoted 0 times

...

Fletcher

16 days ago

I think the answer is A) TIMESTAMP WITH TIMEZONE because it supports date arithmetic.

upvoted 0 times

...

Odette

18 days ago

But TIMESTAMP WITH TIMEZONE can store date arithmetic and support calculations for interest too.

upvoted 0 times

...

Nana

19 days ago

Hmm, TIMESTAMP WITH TIMEZONE seems like the obvious choice here. It can store the date and time with timezone information, and you can do date arithmetic on it. Easy peasy!

upvoted 0 times

...

Golda

23 days ago

I disagree, I believe the correct answer is E) INTERVAL DAY TO SECOND.

upvoted 0 times

...

Arthur

24 days ago

I think INTERVAL DAY TO SECOND is the way to go. It can handle the date arithmetic and the loan period up to 10 years without any conversion functions. This is a no-brainer!

upvoted 0 times

Ernest

5 days ago

I disagree, I think TIMESTAMP would be a better choice. It's more commonly used and easier to work with.

upvoted 0 times

...

Flo

9 days ago

I think INTERVAL DAY TO SECOND is the way to go. It can handle the date arithmetic and the loan period up to 10 years without any conversion functions. This is a no-brainer!

upvoted 0 times

...

Odette

24 days ago

I think the answer is A) TIMESTAMP WITH TIMEZONE.

upvoted 0 times

...