Question

We apply the aggregate function to a group of sets of tuples using the _______ clause.

(a) group by

(b) group

(c) group set

(d) group attribute

This question was addressed to me in a job interview.

My question is taken from Aggregate Functions in division Introduction to Relational Model and Sql of RDBMS

Answer 1

Correct answer is (a) group by

Explanation: We apply the aggregate function to a group of sets of tuples using the group by clause. The group by clause must always be used whenever we are willing to apply the aggregate function to a group of sets of tuples.