OCP-1Z0-051 第80题 DATE数据类型

来源：互联网发布：小米平板2 ubuntu 编辑：程序博客网时间：2024/05/19 11:44

一、原题

Which two statements are true regarding working with dates? (Choose two.)
A. The default internal storage of dates is in the numeric format.
B. The default internal storage of dates is in the character format.
C. The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century.
D. The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required.

答案：AD

二、题目翻译

关于处理日期型数据，哪两句话是正确的？
A. 默认内部存储的日期是使用数字格式。
B. 默认内部存储的日期是使用字符格式。
C. RR日期格式自动从SYSDATE函数中计算出世纪，不允许用户输入世纪。
D. RR日期格式自动从SYSDATE函数中计算出世纪，但是如果需要还允许用户输入世纪。

三、题目解析

A选项正确，详见联机文档的DATE Data Type描述部分:
http://docs.oracle.com/cd/E11882_01/server.112/e40540/tablecls.htm#CNCPT413

摘录如下：
The database stores dates internally as numbers. Dates are stored in fixed-length fields of 7 bytes each, corresponding to century, year, month, day, hour, minute, and second

0 0