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

Question

Share Report Error

Which of the following is NOT an aggregate function in standard SQL?

A. COUNT()

B. SUM()

C. AVG()

D. LENGTH()

Answer: Option D

Solution (By JKExamLibrary)

SUM(), AVG(), and COUNT() are aggregate functions operating on multiple rows, whereas LENGTH() is a scalar function acting on a single text value.

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 of the following is NOT an advantage of DBMS over traditional file systems?

A. Simpler implementation and lower cost

B. Data redundancy control

C. Higher data security

D. Data independence

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DBMS generally involves higher initial costs and complexity compared to simple file systems, though it offers better control over redundancy, independence, and security.

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

Question #2

What is a column in a relational database table formally called?

A. Attribute

B. Degree

C. Entity

D. Tuple

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A column in a database table represents a property or characteristic of the entity and is formally known as an attribute.

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

Question #3

Which of the following is not a type of database model?

A. Hierarchical

B. Object-oriented

C. Flat-file

D. Network

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Flat-file is not a database model; it is a simple file containing records. Hierarchical, Network, Relational, and Object-oriented are database models.

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

Explore All Database Management System (DBMS) MCQs