MCQ Questions

Computer Science - Class 12
Chapter 9 - Structured Query Language

## (D) COUNT

Aggregate functions are those functions which performs a calculation on a set of values and returns a single value.

 Aggregate function Description AVG( ) Returns the average of a set of values . SUM( ) Returns the sum of a set of values . COUNT( ) Returns the number of rows that matches a specific criterion MIN( ) Returns the minimum value in a set of values MAX( ) Returns the maximum value in a set of values

Checking the options:

• (A) AVG - It is an aggregate function
• (B) MAX - It is an aggregate function
• (C) JOIN - It is not an aggregate function
• (D) COUNT - It is an aggregate function

So, the correct answer is (C)

### Transcript

Which of the following is not an aggregate function? (A) AVG (B) MAX (C) JOIN (D) COUNT Answer: Aggregate functions are those functions which performs a calculation on a set of values and returns a single value. Aggregate function Description AVG( ) Returns the average of a set of values. SUM( ) Returns the sum of a set of values. COUNT( ) Returns the number of rows that matches a specific criterion MIN( ) Returns the minimum value in a set of values MAX( ) Returns the maximum value in a set of values Checking the options: (A) AVG - It is an aggregate function (B) MAX - It is an aggregate function (C) JOIN - It is not an aggregate function (D) COUNT - It is an aggregate function So, the correct answer is (C)