Discuss CIW 1D0-541 Exam Topic 5 Question 122

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);

Suggested Answer: C

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

26 comments · newest first

Anjelica 1 month ago

D is too much work. Just update the existing record instead of deleting it.

Gary 2 months ago

Option B looks good too, but it’s a bit more complex than necessary.

Marjory 2 months ago

I agree, C is straightforward. It updates the right tuple without complications.

An 2 months ago

I think option C is the best choice. It clearly specifies the change needed.

Iraida 2 months ago

D is too much work. Just update the existing record with C.

Pauline 2 months ago

Option B seems okay, but it’s unnecessarily complicated.

Andra 3 months ago

Agreed! C is clear and concise. No need for extra steps.

Albina 3 months ago

I think option C is the best. It directly updates the activity.

Valda 3 months ago

D is too much work. Just update, don’t delete!

Aliza 3 months ago

Option B looks good too, but it’s a bit more complex.

Youlanda 3 months ago

Agreed! C is clear and precise. No unnecessary steps.

Ruby 3 months ago

I think option C is the best. It directly updates the activity.

Keneth 4 months ago

Is it really okay to change the primary key like that?

Margot 4 months ago

Definitely going with C, it’s straightforward.

Laurel 5 months ago

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

Malissa 5 months ago

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

Shoshana 6 months ago

Option C looks correct to me!

Diane 6 months ago

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

Roslyn 6 months ago

Definitely going with C, it’s straightforward!

Natalya 6 months ago

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

Leeann 6 months ago

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

Ria 6 months ago

Option C looks correct to me.

Casie 7 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.

Marylou 7 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.

Barney 7 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.

Evan 7 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.

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