ocp考試題庫：11g-1Z0-051-v9.02-019題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯(lián)系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp考試題庫：11g-1Z0-051-v9.02-019題,完整題庫請點擊這里聯(lián)系老師咨詢了解
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天)
PostgreSQL入門到精通 100+ 個學習資料
- 陳衛(wèi)星-老師CUUG金牌講師
- 陳老師 CUUG金牌講師 精通Oracle管理、備份恢復、性能優(yōu)化 11年Ora...[詳細了解老師]
