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

Marylou

4 days 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

9 days 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

14 days 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

...