一、原题
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. 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. 默认内部存储的日期是使用数字格式。
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
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