Which of the following is not an aggregate function in SQL? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is not an aggregate function in SQL?

A. MAX

B. AVG

C. SUM

D. DESC

Answer: Option D

Solution (By JKSSB Mock Tests)

DESC is a keyword for sorting order, not an aggregate function.

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

Which rule state that 'no component of a primary key can accept a NULL value'?

A. Domain Constraint Rule

B. Security Integrity Rule

C. Entity Integrity Rule

D. Referential Integrity Rule

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Entity Integrity Rule states that a primary key column cannot contain NULL values, ensuring each row can be explicitly identified.

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

Question #2

What is the purpose of the REVOKE command in SQL?

A. To delete a table

B. To create a user

C. To remove user permissions

D. To rollback a transaction

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
REVOKE is used to take away privileges previously granted to users.

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

Question #3

What is the purpose of the SQL 'DEFAULT' constraint?

A. To provide a default value for a column when no value is supplied

B. To enforce uniqueness

C. To set a foreign key

D. To define a primary key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DEFAULT assigns a default value to a column if an INSERT statement does not specify a value.

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

Explore All Database Management System (DBMS) MCQs