Chinaunix首页 | 论坛 | 博客
  • 博客访问: 21905
  • 博文数量: 36
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 210
  • 用 户 组: 普通用户
  • 注册时间: 2021-11-30 10:47
文章分类
文章存档

2022年(28)

2021年(8)

我的朋友

分类: Oracle

2021-12-24 15:28:01

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

阅读(456) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~