Multiple choice

Which of the following statements is/are true? (a) The where clause searches the rows after they are grouped by using 'group by' clause. (b) The 'group by' clause collects rows that meet the where clause search conditions and places those rows into a group for each unique value in the ' group by' clause. (c) Omitting the 'group by' clause creates a single group for the whole table. Table1

NAME

ABLE BAKER CHARLIE DEAN

Table2

NAME

ABLE BAKER BRAVO CHARLIE DECON

  1. a and b

  2. b and c

  3. a and c

  4. All of these

  5. Only b

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

As per explanation for option 1, statement 'b' is true. If it doesn't use the 'group by' clause, a single group is created for the whole table.

Keep practicing — related questions