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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

CIW 1D0-541 Exam - Topic 8 Question 129 Discussion

Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the Recreation relation that will return the following data:Which SQL statement applied to the Recreation relation will return this data?
B) SELECT DISTINCT Activity FROM Recreation;
A) SELECT Activity FROM Recreation;
C) SELECT Activity FROM Recreation WHERE NOT LIKE Activity;
D) SELECT Activity FROM Recreation WHERE DISTINCT Activity;

CIW 1D0-541 Exam - Topic 8 Question 129 Discussion

Actual exam question for CIW's 1D0-541 exam
Question #: 129
Topic #: 8
[All 1D0-541 Questions]

Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the Recreation relation that will return the following data:

Which SQL statement applied to the Recreation relation will return this data?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Wilburn at Jun 30, 2026, 06:18 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Lili
2 days ago
D doesn’t make any sense, what’s that syntax?
upvoted 0 times
...
Ressie
7 days ago
I’m surprised that C is even an option!
upvoted 0 times
...
Marylou
12 days ago
Wait, can you even use WHERE with DISTINCT?
upvoted 0 times
...
Willard
17 days ago
I think A is enough, why use DISTINCT?
upvoted 0 times
...
Micheline
22 days ago
Option B is the correct choice!
upvoted 0 times
...
Clarence
27 days ago
I'm confused about option D; it doesn't seem like valid SQL syntax. I think it might be a trick option.
upvoted 0 times
...
Sharee
1 month ago
Option C seems off to me; I don't recall using NOT LIKE in this context. It feels like it wouldn't return the right results.
upvoted 0 times
...
An
1 month ago
I remember practicing a similar question where we had to use DISTINCT to filter out duplicates. That might be relevant here.
upvoted 0 times
...
Tu
1 month ago
I think the question is asking for unique activities, so maybe option B? But I'm not entirely sure.
upvoted 0 times
...

Save Cancel