Oracle
1Z0-082 · Question #53
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…
The correct answer is B. INTERVAL DAY TO SECOND. You've hit your weekly limit · resets 5am (America/New_York)
SQL and PL/SQL
Question
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?
Options
- AINTERVAL YEAR TO MONTH
- BINTERVAL DAY TO SECOND
- CTIMESTAMP WITH LOCAL TIMEZONE
- DTIMESTAMP
- ETIMESTAMP WITH TIMEZONE
How the community answered
(63 responses)- A2% (1)
- B84% (53)
- C2% (1)
- D5% (3)
- E8% (5)
Explanation
You've hit your weekly limit · resets 5am (America/New_York)
Topics
#INTERVAL DAY TO SECOND#date arithmetic#data type selection#interval types
Community Discussion
No community discussion yet for this question.