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

Last updated at Dec. 14, 2024 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)

Go Ad-free

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 has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo