本文探讨了在创建银行业务应用程序表时，如何选择合适的字段数据类型来存储信贷期限。该字段需要能够直接与DATE类型进行加减运算，且最大信贷期限为30天，并用于计算实际天数的利息。
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?
（你须要创建一个银行业务表，当中一个字段有例如以下要求：
1）该字段须要存储信贷期限的持续时间。
2）不使用转换函数，就能够简单的和Date数据类型加减。
3）应用中信贷发放的最大周期是30天
4）已经拥有信用卡的个人，按天计算利息。）
A. DATE
B. NUMBER
C. TIMESTAMP
D. INTERVAL DAY TO SECOND
A：Date类型存储的是一个时间点，不是一段时间 （错误）
B：number类型不能和date类型简单的加减 （错误）
C: 和A一样存储的是时间点（错误）
D: 正确
E: 错误，不能精确到天
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?
（你须要创建一个银行业务表，当中一个字段有例如以下要求：
1）该字段须要存储信贷期限的持续时间。
2）不使用转换函数，就能够简单的和Date数据类型加减。
3）应用中信贷发放的最大周期是30天
4）已经拥有信用卡的个人，按天计算利息。）
A. DATE
B. NUMBER
C. TIMESTAMP
D. INTERVAL DAY TO SECOND
E. INTERVAL YEAR TO MONTH
A：Date类型存储的是一个时间点，不是一段时间 （错误）
B：number类型不能和date类型简单的加减 （错误）
C: 和A一样存储的是时间点（错误）
D: 正确
E: 错误，不能精确到天
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
