Consider the Orders relation shown in the exhibit.
Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?
A.
UPDATESales_Rep_No
IN Orders
SET(Sales_Rep_No = 110
WHERE Sales_Rep_No = 108);
B.
UPDATE Orders
SET Sales_Rep_No = 110
WHERE Sales_Rep_No = 108;
C.
UPDATE Orders
SET Sales_Rep_No = 110;
D.
UPDATE Orders
WHERE Sales_Rep_No = 108
SET Sales_Rep_No = 110;