大数据就业实战培训 Oracle就业实战培训
071考试题库之前是比较稳定的，但随着Oracle的调整，071考试不断的增加新的考题，增加了考试的难度，所以我们专门收集整理了这些考试，并对这些考题进行解析，希望可以对考生有帮助。
每周五晚8点，我们有免费的OCP解析公开课，地址：https://ke.qq.com/course/326223 OCP题库交流群：1015267481，验证ocp
-------------------------------------------------------
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 的信息)
