Which SQL function is used to find the maximum value in a column? MCQ with Answer and Explanation

Question

Share Report Error

Which SQL function is used to find the maximum value in a column?

A. SUM()

B. MIN()

C. AVG()

D. MAX()

Answer: Option D

Solution (By JKSSB Mock Tests)

MAX() returns the highest value in a selected 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

What is the difference between a clustered and a non-clustered index?

A. Non-clustered determines physical order; clustered is logical

B. Clustered index determines physical order; non-clustered is a logical order

C. They both determine physical order

D. There is no difference

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A clustered index sorts the data rows and stores them in that order; a non-clustered index is a separate structure with pointers to data rows.

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

Question #2

Which language is used to define the structure of a database, such as creating tables and constraints?

A. TCL

B. DML

C. DDL

D. DCL

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Data Definition Language (DDL) is used to define and modify the database schema, including CREATE, ALTER, and DROP statements.

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

Question #3

Which schema architecture level describes how the data is physically stored on disk storage media?

A. Internal Level

B. Logical Level

C. Conceptual Level

D. External Level

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Internal (or Physical) level of the three-schema architecture describes the physical storage structure and access paths of the database.

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

Explore All Database Management System (DBMS) MCQs