Which SQL function returns the average of a numeric column? MCQ with Answer and Explanation

Question
Which SQL function returns the average of a numeric column?
A. MEAN()
B. AVG()
C. SUM()
D. COUNT()
Answer: Option B
Solution (By JKSSB Mock Tests)
AVG() calculates the average of the values in a numeric column.
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 SQL command is used to reverse or undo all modifications made during the current transaction that have not yet been committed?
A. REVERT
B. SAVEPOINT
C. UNDO
D. ROLLBACK
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The ROLLBACK command is a TCL statement used to undo transactions, restoring the database to its last committed or safe state.
This question belongs to: Computer Database Management System (DBMS)
Question #2
Which language category in SQL is used by database administrators to grant and revoke access privileges and security permissions?
A. DDL
B. DML
C. TCL
D. DCL
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Data Control Language (DCL) includes commands like GRANT and REVOKE, which manage privileges and security configurations for database users.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a valid SQL statement to create a view?
A. Both A and B
B. Neither
C. CREATE VIEW view_name AS SELECT ...;
D. CREATE VIEW view_name (columns) AS SELECT ...;
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both syntaxes are valid: CREATE VIEW view_name AS SELECT ... and with column aliases.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?