Question 4 - MCQ Questions - Chapter 9 - Structured Query Language

Last updated at July 14, 2026 by

The MAX () function finds the

(A) Maximum number of records entered in a table

(B) Maximum number of rows allowed to be entered

(C) Maximum value of the selected column

(D) None of these

 

Answer:

The MAX( ) function is an aggregate function in SQL which returns the maximum value from a set of values.

Checking the options

  • (A) Maximum number of records entered in a table - MAX( ) function does not return this
  • (B) Maximum number of rows allowed to be entered - MAX( ) function does not return this
  • (C) Maximum value of the selected column - MAX( ) function returns this
  • (D) None of these  

So, the correct answer is (C)

Remove Ads
Teachoo · Class 12 Explore Class 12

Transcript

The MAX () function finds the (A) Maximum number of records entered in a table (B) Maximum number of rows allowed to be entered (C) Maximum value of the selected column (D) None of these Answer: The MAX( ) function is an aggregate function in SQL which returns the maximum value from a set of values. Checking the options (A) Maximum number of records entered in a table - MAX( ) function does not return this (B) Maximum number of rows allowed to be entered - MAX( ) function does not return this (C) Maximum value of the selected column - MAX( ) function returns this (D) None of these So, the correct answer is (C)

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh is an IIT Kanpur graduate and has been teaching for 16+ years. At Teachoo, he breaks down Maths, Science and Computer Science into simple steps so students understand concepts deeply and score with confidence.

Many students prefer Teachoo Black for a smooth, ad-free learning experience.