Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

CIW Exam 1D0-541 Topic 3 Question 81 Discussion

Actual exam question for CIW's 1D0-541 exam
Question #: 81
Topic #: 3
[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?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

Truman
3 months ago
I see your point, maybe I'll reconsider my answer.
upvoted 0 times
...
Jordan
3 months ago
I agree with Dorsey, B seems more comprehensive.
upvoted 0 times
...
Dorsey
4 months ago
But in option B, it specifies to update both Activity and Activity_Fee.
upvoted 0 times
...
Truman
5 months ago
I disagree, I believe it's C.
upvoted 0 times
...
Dorsey
5 months ago
I think the correct answer is B.
upvoted 0 times
...

Save Cancel