Check sibling questions

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

Last updated at May 29, 2023 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)

Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class

Book a free demo

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)

Ask a doubt
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 13 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.