oracle ocp 19c考题,科目082考试题-banking application data type

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

Source:cuug

posted on 2021-12-24 15:28  alice9313  阅读(69)  评论(0)    收藏  举报

导航