CIW 1D0-541 Exam - Topic 5 Question 122 Discussion

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

Question #: 122
Topic #: 5

[All 1D0-541 Questions]

Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples

for Student_ID 1003 must be performed. It is necessary to change one of the activities from

swimming to tennis. The Student_ID and Activity attributes make up the primary key for the

Recreation relation. All related information must be altered, as well. Which SQL statement or

statements would best accomplish this?

AUPDATE Recreation
SET Activity, Activity_Fee ('Tennis', 100)
WHERE Student_ID = 1003;

BUPDATE TABLE Recreation
SET ACTIVITY = 'Tennis', Activity_Fee = 100
WHERE Student_ID = 1003
AND Activity = Swimming;

CUPDATE Recreation
SET Activity = 'Tennis', Activity_Fee = 100
WHERE Student_ID = 1003
AND Activity = 'Swimming';

DDELETE Activity
FROM Recreation
WHERE Student_ID = 1003;
INSERT INTO Recreation
VALUES (1003, 'Tennis', 100);

Show Suggested Answer

Suggested Answer: C

by Katlyn at Mar 06, 2026, 07:57 PM

Limited Time Offer

25%

Off

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Laurel

6 days ago

Wait, why would you delete and insert? That's unnecessary!

upvoted 0 times

...

Malissa

12 days ago

I think B is better since it specifies the current activity.

upvoted 0 times

...

Shoshana

17 days ago

Option C looks correct to me!

upvoted 0 times

...

Diane

22 days ago

Is it really okay to assume the fee is always 100? Seems odd.

upvoted 0 times

...

Roslyn

27 days ago

Definitely going with C, it’s straightforward!

upvoted 0 times

...

Natalya

1 month ago

Wait, why would you delete and insert? D seems unnecessary.

upvoted 0 times

...

Leeann

1 month ago

I think B is better since it checks for the current activity.

upvoted 0 times

...

Ria

1 month ago

Option C looks correct to me.

upvoted 0 times

...

Casie

2 months ago

I feel like option B is close, but it has the wrong syntax with "UPDATE TABLE." I think option C is definitely the best choice here.

upvoted 0 times

...

Marylou

2 months ago

I’m a bit confused about the DELETE and INSERT approach in option D. It seems like overkill for just changing an activity.

upvoted 0 times

...

Barney

2 months ago

I remember practicing a similar question where we had to update multiple fields. I think option C looks correct since it specifies both the new activity and the fee.

upvoted 0 times

...

Evan

2 months ago

I think we need to use the UPDATE statement, but I'm not sure if we should include the condition for the current activity.

upvoted 0 times

...