Check sibling questions

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

Last updated at May 29, 2023 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)

Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class

Book a free demo

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)

Ask a doubt
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 13 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.