ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-082 All Questions

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

Exam 1z0-082 topic 1 question 6 discussion

Actual exam question from Oracle's 1z0-082
Question #: 6
Topic #: 1
[All 1z0-082 Questions]

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 Hide Answer
Suggested Answer: B 🗳️
by Ekos at Oct. 23, 2020, 8:36 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
emmededalus
2 weeks, 4 days ago
Selected Answer: B
B - true; this interval can store days
upvoted 1 times
...
nautil2
4 months 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, 2 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
LeandroHPN
1 year, 6 months ago
Selected Answer: B
B is correct
upvoted 2 times
...
thuto
1 year, 8 months ago
It is B... :)
upvoted 1 times
...
ryuah
2 years ago
B is correct
upvoted 1 times
...
ty_1
2 years, 8 months ago
yes B is correct one
upvoted 1 times
...
khizar782
2 years, 8 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, 2 months ago
Yes: B'
upvoted 2 times
...
Ekos
3 years, 2 months ago
agree, b is the correct answer
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago