Oracle OCP认证考试题目详解082系列第6题

💡解答一、考察的知识点摘要本题考察Oracle的时间间隔INTERVAL数据类型与TIMESTAMP时间戳系列类型的区别，重点区分INTERVAL YEAR TO MONTH和INTERVAL DAY TO SECOND的适用业务场景，理解时间间隔类型对日期算术运算的支持特性。二：英文题目和英语选项和答案QuestionYou 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 functionsStore a loan period of up to 10 yearsBe used for calculating interest for the number of days the loan remains unpaidWhich data type should you use?A. INTERVAL YEAR TO MONTHB. INTERVAL DAY TO SECONDC. TIMESTAMP WITH LOCAL TIMEZONED. TIMESTAMPE. TIMESTAMP WITH TIMEZONECorrect Answer：B三：题目和选项的翻译，答案题目：你需要为一个银行应用程序创建一张表。其中某一列必须满足三项需求：存储格式支持日期算术运算，无需使用转换函数可以存储最长10年的贷款周期用于计算贷款未偿还天数对应的利息你应该使用哪种数据类型？A. INTERVAL YEAR TO MONTH（年‑月间隔类型）B. INTERVAL DAY TO SECOND（日‑秒间隔类型）C. TIMESTAMP WITH LOCAL TIMEZONE（带本地时区的时间戳）D. TIMESTAMP（时间戳）E. TIMESTAMP WITH TIMEZONE（带时区的时间戳）✅正确答案：B四：题目解析选项A（错误）：INTERVAL YEAR TO MONTH只保存年、月级别的间隔，没有天、秒的粒度信息，无法精确计算按天计息的利息，不满足第3条需求。-- 创建3年6个月的间隔SQLSELECTINTERVAL'3-6'YEARTOMONTHFROMDUAL;INTERVAL'3-6'YEARTOMONTH---------------------------------------------------------------------------+03-06-- 创建18个月（会自动转为1年6个月）SQLSELECTINTERVAL'18'MONTHFROMDUAL;INTERVAL'18'MONTH---------------------------------------------------------------------------+01-06-- 创建5年SQLSELECTINTERVAL'5'YEARFROMDUAL;INTERVAL'5'YEAR---------------------------------------------------------------------------