Oracle OCP 19c 认证1Z0-082考试题库(第6题)-CUUG整理
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
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。