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

Last updated at Dec. 14, 2024 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)

Go Ad-free

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 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