Question

The COUNT(*) function provides the total number of ______ within a relation (table) in a relational database.

Options

• Columns

• Unique values

• Not-null values

• Rows

Answer 1

The COUNT(*) function provides the total number of rows within a relation (table) in a relational database.

Explanation:

The COUNT(*) method in SQL calculates the total number of rows in a table, including those with null values. It counts all rows, independent of the contents of the columns.