OCP考试题库以前是比较稳定的,但在2018年随着oracle的调整,不断的有新题出现,增加考试的难度,对此,我们专门收集整理了071的考试真题,分享给大家。
--------------------------------------------
071题库分享-第69题、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 秒
)
-----------------------------------------------
OCP解析公开课时间:【每周五晚8点】
OCP解析公开课地址:https://ke.qq.com/course/326223
OCP解析群资料分享:1015267481 验证:ocp
另外,除了OCP公开课,OCM题库直播也同步进行中,OCM最新题库大爆料-【每周四晚8点】,【微信群直播】,可以联系咨询老师进群参与