CIW Exam 1D0-541 Topic 3 Question 81 Discussion

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

Question #: 81
Topic #: 3

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 Erick at Feb 11, 2024, 05:26 PM

Limited Time Offer

25%

7 months ago

I think the correct answer is B.

upvoted 0 times

...