You must create a table for a banking application. (Choose the best answer.)
One of the columns in the table has these requirements:
1: A column to store the duration of a short team loan
2: The data should be stored in a format supporting DATE arithmetic with DATE datatypes without using conversion functions. 3: The maximum loan period is 30 days.
4: Interest must be calculated based on the number of days for which the loan remains unpaid.
Which data type would you use?
A. Date
B. Number
C. Timestamp
D. Interval day to second
E. Interval year to month
|
Download Printable PDF. VALID exam to help you PASS. |
 |