ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

76 / 120

Question 76:

View the Exhibit and examine the structure of the ORDER_ITEMS table. 
image
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? 

Answer options:

A. Remove the GROUP BY clause from the subquery and place it in the main query
B. Replace = with the >ANY operator
C. Replace = with the >ALL operator
D. Replace = with the IN operator