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

Question
Which of the following is a non-aggregate function in SQL?
A. COUNT()
B. LENGTH()
C. SUM()
D. AVG()
Answer: Option B
Solution (By JKSSB Mock Tests)
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)
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 a valid SQL command to delete a database?
A. DELETE DATABASE
B. TRUNCATE DATABASE
C. DROP DATABASE
D. REMOVE DATABASE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
DROP DATABASE is the SQL command to delete an entire database.
This question belongs to: Computer Database Management System (DBMS)
Question #2
In DBMS, what is the role of a DBA?
A. Database Administrator who manages the database system
B. Dynamic Binary Analyzer
C. Database Application Builder
D. Data Backup Assistant
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Database Administrator (DBA) is responsible for designing, implementing, maintaining, and securing the database.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which SQL statement is used to delete an existing view from the database catalog?
A. REMOVE VIEW
B. DELETE VIEW
C. CLEAR VIEW
D. DROP VIEW
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Because a View is a database structural object, it is removed from the database schema using the DDL command 'DROP VIEW'.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: