Oracle OCP 19c 认证1Z0-082考试题库（第6题）

Oracle OCP 19c 认证1Z0-082考试题库(第6题)-CUUG内部学员版082题库解析

You 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 functions

Store a loan period of up to 10 years

Be used for calculating interest for the number of days the loan remains unpaid

Which data type should you use?

A. INTERVAL YEAR TO MONTH

B. INTERVAL DAY TO SECOND

C. TIMESTAMP WITH LOCAL TIMEZONE

D. TIMESTAMP

E. TIMESTAMP WITH TIMEZONE

Answer: B

(解析：这是一个很经典的应用，如果有相关的银行业务，需要计算贷款未付天数的利息，那么选择 INTERVAL DAY TO SECOND 数据类似是非常合适的，在 10g-19c 版本中都出现过该题目，有些 OCP 的题库是跟版本没有关系的，是有关应用的内容。)