OCP考试题库以前是比较稳定的,但在2018年随着oracle的调整,不断的有新题出现,增加考试的难度,对此,我们专门收集整理了071的考试真题,分享给大家。
--------------------------------------------
15.choose the best answer
View the Exhibit and examine the structure of the ORDER_ITEMS table.
Examine the following SQL statement:
SELECT order_id, product_id, unit_price
FROM order_items
WHERE unit_price =
(SELECT MAX(unit_price)
FROM order items
GROUP BY order_id);
You want to display the PRODUCT_ID of the product that has the highest UNIT_PRICE per ORDER_ID.
What correction should be made in the above SQL statement to achieve this?
A) Replace = with the >ALL operator.
B) Replace = with the >ANY operator.
C) Remove the GROUP BY clause from the subquery and place it in the main query.
D) Replace = with the IN operator.
Answer:D
(解析:题意是希望显示每个 ORDER_ID 具有最高 UNIT_PRICE 的产品的 PROT_ID 的信息)
--------------------------------------------
OCP解析公开课时间:【每周五晚8点】
OCP解析公开课地址:https://ke.qq.com/course/326223
OCP解析群资料分享:1015267481 验证:ocp
另外,除了OCP公开课,OCM题库直播也同步进行中,OCM最新题库大爆料-【每周四晚8点】,【微信群直播】,可以联系咨询老师进群参与