OCP 1Z0 051 19

来源：互联网发布：如何修改mysql字符集编辑：程序博客网时间：2024/06/05 09:20

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
考点：INTERVAL
注意下面各语句的返回格式

SQL> select INTERVAL '20' year as "year" from dual;year---------------------------------------+20-001 row selectedSQL> select INTERVAL '30' month as "month" from dual;month---------------------------------------+02-061 row selectedSQL> select INTERVAL '90' day as "day" from dual;day---------------------------------------+90 00:00:001 row selectedSQL> select INTERVAL '72' hour as "hour" from dual;hour---------------------------------------+03 00:00:001 row selectedSQL> select INTERVAL '80' minute as "minute" from dual;minute---------------------------------------+00 01:20:001 row selectedExecuted in 0.015 secondsSQL> select INTERVAL '3.15' second as "second" from dual;second---------------------------------------+00 00:00:03.1500001 row selectedSQL> select INTERVAL '2 12:30:59' DAY to second as "DAY to second" from dual;DAY to second---------------------------------------+02 12:30:59.0000001 row selectedSQL> select INTERVAL '13-3' year to month as "Year to month" from dual;Year to month---------------------------------------+13-031 row selected

SQL> SELECT INTERVAL '300' MONTH,  2         INTERVAL '54-2' YEAR TO MONTH,  3         INTERVAL '11:12:10.1234567' hour TO SECOND  4    FROM dual;INTERVAL'300'MONTH   INTERVAL'54-2'YEARTOMONTH      INTERVAL'11:12:10.1234567'HOUR-------------------- ------------------------------ ---------------------------------------+25-00               +54-02                         +00 11:12:10.1234571 row selected

Answer: A

0 0