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) UPDATE Sales_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) SET Sales_Rep_No = 110;
D) WHERE Sales_Rep_No = 108

Question

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) UPDATE Sales_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) SET Sales_Rep_No = 110; 
D) WHERE Sales_Rep_No = 108

Quizplus · Accepted Answer

The Answer of 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) UPDATE Sales_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) SET Sales_Rep_No = 110; 
D) WHERE Sales_Rep_No = 108

Consider the Orders Relation Shown in the Exhibit