MCQ Questions

Computer Science - Class 12
Chapter 9 - Structured Query Language

(D) Both (a) and (b)

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

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)