What result set will the following query return? Select Item_No
From Order_V
Where quantity 10;
A) The Item_No of all orders that had more than 10 items
B) The Order_Id of all orders that had more than one item
C) The Order_Id of all orders that had more than 10 items
D) The Item_No of all orders that had 10 or more items

Question

What result set will the following query return? Select Item_No
From Order_V
Where quantity > 10;
A) The Item_No of all orders that had more than 10 items
B) The Order_Id of all orders that had more than one item
C) The Order_Id of all orders that had more than 10 items
D) The Item_No of all orders that had 10 or more items

Quizplus · Accepted Answer

The query selects Item_No from the Order_V view where the quantity is greater than 10, which matches option A.

What Result Set Will the Following Query Return? Select Item_No