本文探讨了在银行应用中为存储信用周期持续时间的表列选择最佳数据类型的问题，包括日期格式的加减操作、最大期限限制以及按天计算利息的需求。
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 should be stored in a format such that it can be easily added and subtracted
with
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 for.
Which data type would you use for such a column in the table?
A. DATE
B. NUMBER
C. TIMESTAMP
D. INTERVAL DAY TO SECOND
E. INTERVAL YEAR TO MONTH
Answer: D
答案解析：
参考：http://blog.csdn.net/rlhua/article/details/12905109
题意要求
1) 你想让该列存储信贷周期的持续时间
2) 该列的日期格式如下：它能非常容易的与DATE数据类型进行加减，无需使用转换函数
3) 应用程序中的最大信贷条款周期是30天
4) 已经使用信用卡的个人按天计算利息
A和C都是存储的时间点，不是一段时间，而B是数值型数据不能满足条件，E不正确因为虽然它也是存储一段时间但是，是从年到月的，不能满足第3条和第4条件需要精确到天
扫一扫
5391
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
