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?
A) SELECT Activity FROM Recreation;
B) SELECT DISTINCT Activity FROM Recreation;
C) SELECT Activity FROM Recreation WHERE NOT LIKE Activity;
D) WHERE DISTINCT Activity;

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? 
A) SELECT Activity FROM Recreation; 
B) SELECT DISTINCT Activity FROM Recreation; 
C) SELECT Activity FROM Recreation WHERE NOT LIKE Activity; 
D) WHERE DISTINCT Activity;

Quizplus · Accepted Answer

The Answer of 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? 
A) SELECT Activity FROM Recreation; 
B) SELECT DISTINCT Activity FROM Recreation; 
C) SELECT Activity FROM Recreation WHERE NOT LIKE Activity; 
D) WHERE DISTINCT Activity;

Consider the Recreation Relation Shown in the Exhibit