Question:medium

In SQL, the aggregate function which will display the cardinality of the table is \(\_\_\_\_\_\). 
 

Show Hint

Use count(*) when you need to determine the total number of rows in a table, regardless of whether they contain NULL values or not.

Updated On: Jan 13, 2026

  • sum()
     

  • count(*) 
     

  • avg()
     

  • sum(*)
     

Show Solution

The Correct Option is B

Solution and Explanation

The SQL COUNT(*) function determines the number of rows within a table, thereby indicating its cardinality. Functions such as SUM() and AVG() are reserved for numerical aggregations, not row counting.

Was this answer helpful?
0

Top Questions on Types of Functions

Questions Asked in CBSE Class XII exam