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

Share Report

In an Entity-Relationship (ER) diagram, what geometric shape is used to represent an entity type?

A. Rectangle

B. Diamond

C. Triangle

D. Ellipse

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In standard ER modeling notation, rectangles are used to represent entity sets or entity types.

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

Question #2

Share Report

A Primary Key in RDBMS must be:

A. Always a foreign key

B. Duplicate values allowed

C. Can have null values

D. Unique and not null

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A primary key uniquely identifies each record and cannot contain null values.

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

Question #3

Share Report

Which of the following is an example of a NoSQL database?

A. Oracle

B. MySQL

C. PostgreSQL

D. MongoDB

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
MongoDB is a document-oriented NoSQL database. PostgreSQL, MySQL, and Oracle are RDBMS.

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

Explore All Database Management System (DBMS) MCQs