CIW Exam 1D0-541 Topic 1 Question 97 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 97
Topic #: 1

[All 1D0-541 Questions]

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?

AUPDATE Sales_Rep_No
IN Orders
SET(Sales_Rep_No = 110
WHERE Sales_Rep_No = 108);

BUPDATE Orders
SET Sales_Rep_No = 110
WHERE Sales_Rep_No = 108;

CUPDATE Orders
SET Sales_Rep_No = 110;

DUPDATE Orders
WHERE Sales_Rep_No = 108
SET Sales_Rep_No = 110;

Show Suggested Answer

Suggested Answer: B

by Leonor at Sep 14, 2024, 10:15 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

16 hours ago

I'm going with B. The other options either don't target the right column or don't have the WHERE clause to only update the specific rows we want.

upvoted 0 times

...

10 days ago

Why do you think A is the correct answer?

upvoted 0 times

...

10 days ago

Option B looks like the correct way to update the Sales_Rep_No column with 110 where it is currently 108. Straightforward and efficient.

upvoted 0 times

...

13 days ago

I disagree, I believe the answer is A.

upvoted 0 times

...

17 days ago

I think the correct answer is B.

upvoted 0 times

...