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?
Suggested Answer: B
Get Premium 1D0-541 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
27 comments · newest first
VI
Vivan
4 days ago
Let's hope for the best!
FA
Fannie
9 days ago
B covers all bases.
YA
Yaeko
14 days ago
I feel unsure about this one.
KA
Karol
19 days ago
I agree, B is clear.
VI
Vivan
25 days ago
D is confusing.
FA
Fannie
30 days ago
C doesn't make sense to me.
YA
Yaeko
1 month ago
A seems too simple.
KA
Kati
1 month ago
It returns unique activities.
KA
Karol
2 months ago
Why B?
KA
Kati
2 months ago
I think B is the best choice.
VI
Vivan
2 months ago
This question is tricky.
TA
Talia
2 months ago
I’m with you all. B is the clear winner!
SI
Simona
2 months ago
Definitely B! We need distinct values only.
GI
Gilma
2 months ago
Option D doesn’t make sense. WHERE DISTINCT?
QU
Quentin
3 months ago
I feel like option C is confusing. NOT LIKE?
RE
Reena
3 months ago
Option A might return duplicates. Not ideal.
EL
Elvera
3 months ago
Agreed! DISTINCT is key here.
CE
Celestine
3 months ago
I think option B is the best choice. It gets unique activities.
LI
Lili
3 months ago
D doesn’t make any sense, what’s that syntax?
RE
Ressie
3 months ago
I’m surprised that C is even an option!
MA
Marylou
4 months ago
Wait, can you even use WHERE with DISTINCT?
WI
Willard
4 months ago
I think A is enough, why use DISTINCT?
MI
Micheline
4 months ago
Option B is the correct choice!
CL
Clarence
4 months ago
I'm confused about option D; it doesn't seem like valid SQL syntax. I think it might be a trick option.
SH
Sharee
4 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.
AN
An
4 months ago
I remember practicing a similar question where we had to use DISTINCT to filter out duplicates. That might be relevant here.
TU
Tu
5 months ago
I think the question is asking for unique activities, so maybe option B? But I'm not entirely sure.