ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
分类： Oracle
2019-03-08 09:37:48
69、(31-1)choose the best answer:
Evaluate the following query:
SELECT INTERVAL '300' MONTH,
INTERVAL '54-2' YEAR TO MONTH,
INTERVAL '11:12:10.1234567' HOUR TO SECOND
FROM dual;
What is the correct output of the above query?
A) +25-00 , +00-650, +00 11:12:10.123457
B) +25-00 , +54-02, +00 11:12:10.123457
C) +00-300, +00-650, +00 11:12:10.123457
D) +00-300, +54-02, +00 11:12:10.123457
Answer：B
(解析：
INTERVAL '300' MONTH：300 个月为+25-00(25 年，即 25*12+0)
INTERVAL '54-2' YEAR TO MONTH：+54-02，表示 54 年零 2 个月
INTERVAL '11:12:10.1234567' HOUR TO SECOND: +00 11:12:10.123457(+00 表示 0 天)，表示 11 个小时，12 分，10.123457 秒
)
