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

Last updated at July 14, 2026 by

Which of the following function gives the total number of rows in a given column or expression?

(A) SUM()

(B) COUNT()

(C) TOTAL()

(D) Both (a) and (b)

 

Answer:

Checking the options

  • (A) SUM() - It returns the total sum of a numeric column.  
  • (B) COUNT() - It returns the number of rows that matches a specified criterion.
  • (C) TOTAL() - It is not an aggregate function in SQL.
  • (D) Both (a) and (b) 

From the above explanation, we understand that it is the COUNT( ) function which gives the total number or rows in a given column or expression.

So, the correct answer is (B)

Remove Ads

Transcript

Which of the following function gives the total number of rows in a given column or expression? (A) SUM() (B) COUNT() (C) TOTAL() (D) Both (a) and (b) Answer: Checking the options (A) SUM() - It returns the total sum of a numeric column. (B) COUNT() - It returns the number of rows that matches a specified criterion. (C) TOTAL() - It is not an aggregate function in SQL. (D) Both (a) and (b) From the above explanation, we understand that it is the COUNT( ) function which gives the total number or rows in a given column or expression. So, the correct answer is (B)

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.