OCP-1Z0-051-V9.02-22题

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条件需要精确到天