ocp考試題庫：11g-1Z0-051-v9.02-022題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp考試題庫：11g-1Z0-051-v9.02-022題,完整題庫請點擊這里聯系老師咨詢了解
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
試題解析：
題意要求
1) 你想讓該列存儲信貸周期的持續時間
2) 該列的日期格式如下：它能非常容易的與DATE數據類型進行加減，無需使用轉換函數
3) 應用程序中的最大信貸條款周期是30天
4) 已經使用信用卡的個人按天計算利息
A和C都是存儲的時間點，不是一段時間，而B是數值型數據不能滿足條件，E不正確因為雖然它也是存儲一段時間但是，是從年到月的，不能滿足第3條和第4條件需要精確到天
