当前位置： 071题库 > 【第15题】OCP认证1Z0-071最新考试题库及答案

【第15题】OCP认证1Z0-071最新考试题库及答案

来源：优技培训时间：

071考试不仅是OCP11g的考试科目，同时也是OCP 12c的考试科目，所以关心071考题的同学有很多，对此我们专门收集整理了近期071考试的原题，并对这些考题进行讲解，希望帮助广大考生顺利通过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解析群资料分享：1015267481 验证：ocp

另外，除了OCP公开课，OCM题库直播也同步进行中，OCM最新题库大爆料-【每周四晚8点】，【微信群直播】，可以联系咨询老师进群参与