Oracle OCP 19c 認(rèn)證1Z0-082考試題庫(第6題)-CUUG內(nèi)部學(xué)員版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

(解析：這是一個很經(jīng)典的應(yīng)用，如果有相關(guān)的銀行業(yè)務(wù)，需要計算貸款未付天數(shù)的利息，那么選擇 INTERVAL DAY TO SECOND 數(shù)據(jù)類似是非常合適的，在 10g-19c 版本中都出現(xiàn)過該題目，有些 ocp 的題庫是跟版本沒有關(guān)系的，是有關(guān)應(yīng)用的內(nèi)容。)