CIW
1D0-541 · Question #91
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?
The correct answer is B. UPDATE Orders. See the full explanation below for the reasoning.
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?
Exhibit
Options
- AUPDATE Sales_Rep_No
- BUPDATE Orders
- CUPDATE Orders
- DUPDATE Orders
How the community answered
(60 responses)- A5% (3)
- B85% (51)
- C8% (5)
- D2% (1)
Community Discussion
No community discussion yet for this question.