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

Last updated at April 16, 2024 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)

Go Ad-free

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 has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo