Q: 71 Which three are DATETIME data types that can be used when specifying
column definitions? (Choose three.)
A. TIMESTAMP
B. INTERVAL MONTH TO DAY
C. INTERVAL DAY TO SECOND
D. INTERVAL YEAR TO MONTH
E. TIMESTAMP WITH DATABASE TIMEZONE
Answer: A, C, D
这道题目为什么选择ACD呢，BE有啥错啊？
------解决方案--------------------------------------------------------
貌似是Oracle 11g的东西,题目不是很懂,看英文教材把
------解决方案--------------------------------------------------------
又是E文的.帮顶.
------解决方案--------------------------------------------------------
这道题 意思就是 下面哪3项 既是DATETIME 数据类型 并且 该数据类型在定义列时能被使用
答案 我也要查文档 我一直在用的是9i 呵呵10g 11g一直没用过
------解决方案--------------------------------------------------------
The TIMESTAMP data types:
TIMESTAMP
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
The INTERVAL data types:
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
------解决方案--------------------------------------------------------
没有INTERVAL MONTH TO DAY 这个列类型,查资料既可.
http://www.oracle.com/pls/db111/homepage
------解决方案--------------------------------------------------------
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/sql_elements001.htm#i54330