Q21 You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
Be stored in a format supporting date arithmetic without using conversion functions Store a loan period of up to 10 years 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
Answer: B