Question 8 - MCQ Questions - Chapter 9 - Structured Query Language

Last updated at July 14, 2026 by

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)

Remove Ads

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)

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh is an IIT Kanpur graduate and has been teaching for 16+ years. At Teachoo, he breaks down Maths, Science and Computer Science into simple steps so students understand concepts deeply and score with confidence.

Many students prefer Teachoo Black for a smooth, ad-free learning experience.