22. You need to create a table for a banking application. One of the columns in the table has the following requirements:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column shoshould be stored in a format such that it can be easily added and subtracted
DATE data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30 days.
4) The interest has to be calculated for the number of days an individual has taken a credit.
Which data type wocould you use for such a column in the table?
(You need to create a banking business table. One of the fields has the following requirements:
1) This field needs to store the duration of the credit period.
2) without using the conversion function, you can simply add or subtract the Date data type.
3) The maximum period for credit issuance is 30 days.
4) if an individual already owns a credit card, the daily interest is calculated .)
A. DATE
B. NUMBER
C. TIMESTAMP
D. INTERVAL DAY TO SECOND
E. INTERVAL YEAR TO MONTH
Answer: D
A: The Date type is stored at A time point, not for A period of time (incorrect)
B: The number type cannot be added or subtracted from the date type (incorrect)
C: Same as A, it stores time points (errors)
D: Correct
E: error, not accurate to day