Which of the following is a non-aggregate function in SQL? MCQ with Answer and Explanation

Question Report Error

Which of the following is a non-aggregate function in SQL?

A. LENGTH()

B. SUM()

C. COUNT()

D. AVG()

Answer: Option A

Solution (By JKExamLibrary)

LENGTH() (or LEN()) is a string function that returns the length of a string, not an aggregate. SUM, COUNT, AVG are aggregates.

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

What is the default sorting order when using ORDER BY without specifying ASC or DESC?

A. Ascending

B. Random

C. No order

D. Descending

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
ORDER BY defaults to ascending (ASC) order.

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

Question #2 Report Error

A key that consists of more than one attribute to uniquely identify rows in a table is called a what?

A. Primary Key

B. Foreign Key

C. Secondary Key

D. Composite Key

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
When a primary key or unique key comprises two or more columns (attributes) combined together, it is known as a Composite Key.

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

Question #3 Report Error

Which of the following is true about a surrogate key?

A. It is a natural key derived from the data

B. It is a foreign key

C. It is an artificial key, usually an auto-increment integer, with no business meaning

D. It is a composite key

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
A surrogate key is a system-generated unique identifier, typically numeric, that has no business significance.

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

Explore All Database Management System (DBMS) MCQs