OCP 11g认证题库详解:1Z0-051-080题
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询OCP 11g认证题库详解:1Z0-051-080题,完整题库请点击这里联系老师咨询了解
80. 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.
Answer: AD
试题解析:
AB,默认内部日期的存储形式是数字形式,所有A对,B错。
A参照Database Concepts的DATE Data Type部分:
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
CD,RR日期格式自动从SYSDATE函数中计算出世纪,但是如果需要还允许用户输入世纪,所有C错,D对。