OCP考试题库：11g-1Z0-051-v9.02-019题

文章来源：更新时间:2016/7/27 14:08:15

在线老师点击咨询：

最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！

我要咨询

OCP考试题库：11g-1Z0-051-v9.02-019题,完整题库请点击这里联系老师咨询了解

19. 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 , +54-02, +00 11:12:10.123457

B. +00-300, +54-02, +00 11:12:10.123457

C. +25-00 , +00-650, +00 11:12:10.123457

D. +00-300 , +00-650, +00 11:12:10.123457

Answer: A

试题解析：

实验验证：

sys@TEST0924> SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH,INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual;

INTERVAL'300'MONTH

---------------------------------------------------------------------------

INTERVAL'54-2'YEARTOMONTH

---------------------------------------------------------------------------

INTERVAL'11:12:10.1234567'HOURTOSECOND

---------------------------------------------------------------------------

+25-00

+54-02

+00 11:12:10.123457

INTERVAL '300' MONTH：300个月为+25-00(25年-0个月，即25*12+0)

INTERVAL '54-2' YEAR TO MONTH：+54-02

INTERVAL '11:12:10.1234567' HOUR TO SECOND: +00 11:12:10.123457(+00表示0天)