Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 6 discussion

Actual exam question from Oracle's 1z0-082

Question #: 6
Topic #: 1

You have been tasked 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?

A. INTERVAL YEAR TO MONTH
B. INTERVAL DAY TO SECOND
C. TIMESTAMP WITH LOCAL TIMEZONE
D. TIMESTAMP
E. TIMESTAMP WITH TIMEZONE

Show Suggested Answer

Suggested Answer: B 🗳️

by Ekos at Oct. 23, 2020, 8:36 a.m.

Comments

Submit Cancel

emmededalus

7 months ago

Selected Answer: B

B - true; this interval can store days

upvoted 1 times

...

nautil2

10 months, 2 weeks ago

Selected Answer: B

A - false; does not meet condition 3, because this interval does not store days B - true; this interval can store days C - false; cannot store period D - false; cannot store period E - false; cannot store period

upvoted 2 times

...

trgbighero

1 year, 9 months ago

Selected Answer: B

B is correct

upvoted 1 times

...

LeandroHPN

2 years ago

Selected Answer: B

B is correct

upvoted 2 times

...

thuto

2 years, 2 months ago

It is B... :)

upvoted 1 times

...

ryuah

2 years, 6 months ago

B is correct

upvoted 1 times

...

ty_1

3 years, 3 months ago

yes B is correct one

upvoted 1 times

...

khizar782

3 years, 3 months ago

Correct Answer is B. Since the third requirement for banking application is 'Be used for calculating interest for the number of days the loan remains unpaid' So, Data Type 'INTERVAL DAY TO SECOND' must be used to calculate duration in number of days.

upvoted 2 times

...

pr0glnx

3 years, 9 months ago

Yes: B'

upvoted 2 times

...

Ekos

3 years, 9 months ago

agree, b is the correct answer

upvoted 4 times

...