Question

Which one of the following statements updates the orderscopy table by changing the shipvia to 5 for orderid "10248"?

A. SET OrdersCopy
UPDATE ShipVia=5
Where OrderiD IN
(SELECT OrderiD
FROM OrdersCopy
WHERE OrderID=10248):
B. UPDATE ShipVia=5
SET Orders Copy
Where OrderID IN
(SELECT OrderiD
FROM OrdersCopy
WHERE OrderiD-10248):
C. UPDATE OrdersCopy
SET ShipVia = 5
Where OrderID IN
(SELECT OrderiD
FROM OrdersCopy
WHERE OrderID=10248):
D. UPDATE Orders Copy
SET ShipVia=5
Where OrderID IN
(SELECT OrderID
FROM OrdersCopy
WHERE OrderID 10258)

Answer 1

C. UPDATE OrdersCopy

SET ShipVia = 5

Where OrderID IN

(SELECT OrderiD

FROM OrdersCopy

WHERE OrderID=10248):

Explanation: Answer A can be eliminated because the command to change a value is SET not UPDATE. Answer B can be eliminated because as previously stated UPDATE in not the command to change a value. Finally, we can eliminate answer D because it has an orderID of 10258.