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
Kati
2 days ago
I think B is the best choice.
upvoted 0 times
...
Vivan
7 days ago
This question is tricky.
upvoted 0 times
...
Talia
13 days ago
I’m with you all. B is the clear winner!
upvoted 0 times
...
Simona
18 days ago
Definitely B! We need distinct values only.
upvoted 0 times
...
Gilma
23 days ago
Option D doesn’t make sense. WHERE DISTINCT?
upvoted 0 times
...
Quentin
28 days ago
I feel like option C is confusing. NOT LIKE?
upvoted 0 times
...
Reena
1 month ago
Option A might return duplicates. Not ideal.
upvoted 0 times
...
Elvera
1 month ago
Agreed! DISTINCT is key here.
upvoted 0 times
...
Celestine
1 month ago
I think option B is the best choice. It gets unique activities.
upvoted 0 times
...
Lili
2 months ago
D doesn’t make any sense, what’s that syntax?
upvoted 0 times
...
Ressie
2 months ago
I’m surprised that C is even an option!
upvoted 0 times
...
Marylou
2 months ago
Wait, can you even use WHERE with DISTINCT?
upvoted 0 times
...
Willard
2 months ago
I think A is enough, why use DISTINCT?
upvoted 0 times
...
Micheline
2 months ago
Option B is the correct choice!
upvoted 0 times
...
Clarence
2 months 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
3 months 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
3 months 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
3 months 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