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

Which property of ACID ensures that a transaction is treated as a single unit that either fully succeeds or fully fails?

A. Consistency

B. Durability

C. Atomicity

D. Isolation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Atomicity ensures that all operations within a transaction are completed successfully; otherwise, the transaction is aborted and all changes are rolled back.

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

Question #2

Share Report

What is a composite key in a database?

A. A key that references another table

B. A key that is made up of multiple columns

C. A key that is a single column

D. A key that is always a foreign key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A composite key is a primary key that consists of two or more columns to uniquely identify a row.

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

Question #3

Share Report

Which SQL command is used to modify the structure of an existing table?

A. MODIFY

B. UPDATE

C. CHANGE

D. ALTER

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
ALTER TABLE is a DDL command used to add, delete, or modify columns and constraints in an existing table.

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

Explore All Database Management System (DBMS) MCQs