Which aggregate function is used to count the number of rows in a table? MCQ with Answer and Explanation

Question Report Error

Which aggregate function is used to count the number of rows in a table?

A. AVG

B. MAX

C. COUNT

D. SUM

Answer: Option C

Solution (By JKExamLibrary)

COUNT returns the number of rows in a table or group.

This question belongs to: Computer Database Management System (DBMS)

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

The command to modify existing records in a table is:

A. MODIFY

B. UPDATE

C. CHANGE

D. ALTER

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
UPDATE is the DML command used to modify data in existing rows.

This question belongs to: Computer Database Management System (DBMS)

Question #2 Report Error

What is the purpose of the SAVEPOINT statement?

A. To release locks

B. To start a new transaction

C. To create a point within a transaction to which you can later roll back

D. To permanently save changes

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
SAVEPOINT creates a named point within a transaction, allowing partial rollback to that point without affecting the entire transaction.

This question belongs to: Computer Database Management System (DBMS)

Question #3 Report Error

In normalization, 1NF requires that:

A. There are no transitive dependencies

B. All attributes have atomic values

C. There are no partial dependencies

D. The table has a primary key

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
First Normal Form (1NF) ensures that each attribute contains only atomic (indivisible) values.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs