近两年来,OCP的考试题库频率变化,不断的增加新考题,071考试就是其中一个,给很多考071的考生造成困扰,对此,我们专门整理了OCP考试里关于071考试的原题,并带上答案,分享给大家。
--------------------------------------------
071题库汇总-第37题、choose the best answer
The PRODUCTS table has the following structure:
Evaluate the following two SQL statements:
SQL>SELECT prod_id, NVL2(prod_expiry_date, prod_expiry_date + 15,'')
FROM products;
SQL>SELECT prod_id, NVL(prod_expiry_date, prod_expiry_date + 15)
FROM products;
Which statement is true regarding the outcome?
A) Both the statements execute and give different results.
B) Both the statements execute and give the same result.
C) Only the second SQL statement executes successfully.
D) Only the first SQL statement executes successfully.
Answer:A
(解析:NVL2 的意思是如果第一个表达式不为空,则返回第二表达式的值,否则返回第三表达式
SQL> select sal,comm,nvl2(comm,comm+10,0) from emp;
SAL COMM NVL2(COMM,COMM+10,0)
---------- ---------- --------------------
800 0
1600 300 310
1250 500 510
2975 0
)
-----------------------------------------------
OCP解析公开课时间:【每周五晚8点】
OCP解析公开课地址:https://ke.qq.com/course/326223
OCP解析群资料分享:1015267481 验证:ocp
另外,除了OCP公开课,OCM题库直播也同步进行中,OCM最新题库大爆料-【每周四晚8点】,【微信群直播】,可以联系咨询老师进群参与