CIW
1D0-541 · Question #7
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…
The correct answer is B. SELECT DISTINCT Activity FROM Recreation. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ASELECT Activity FROM Recreation;
- BSELECT DISTINCT Activity FROM Recreation;
- CSELECT Activity FROM Recreation
- DSELECT Activity FROM Recreation
How the community answered
(63 responses)- A11% (7)
- B81% (51)
- C3% (2)
- D5% (3)
Community Discussion
No community discussion yet for this question.