SQL Questions and Answers – SQL Min and Max Functions

This set of SQL Multiple Choice Questions & Answers (MCQs) focuses on “SQL Min and Max Functions”.

1. Which of the following terms is used to get the smallest value of the selected field?
a) Small( )
b) Smallest( )
c) Min( )
d) Minimum( )
View Answer

2. Which function is used to find out the record with maximum value among a record set?
a) Maximum( )
b) Max( )
c) Large( )
d) Largest( )
View Answer

3. When a date field is used in min( ) function, it returns _________
a) Earliest date
b) Date with latest day irrespective of month and year
c) Latest date
d) Date with earliest day irrespective of month and year
View Answer

4. If min( ) function is used on a field with non-numerical values, the function returns that record which is _________
a) Closest to alphabet Z
b) Closest to alphabet A
c) Closer to the previous field value
d) Closer to the next field value
View Answer

5. When a date field is used with max( ) function, it returns _________
a) Earliest date
b) Date with latest month irrespective of day and year
c) Latest date
d) Date with earliest month irrespective of day and year
View Answer

6. If a non-numerical values field is used in max( ) function, it returns that record which _________
a) Comes first when the field values are arranged in alphabetical order
b) Closer to the previous field value
c) Comes first when the field values are arranged in reverse alphabetical order
d) Closer to the next field value
View Answer

7. How many arguments does a MIN or MAX function can have?
a) Zero
b) One
c) Should specified by the user
d) Two
View Answer

8. What is the syntax to get minimum value of a field?
a) Select min(column_name) from table_name Where condition(s);
b) Select minimum(column_name) from table_name Where condition(s);
c) Select column_name from table_name Where min(column_name);
d) Select min( ) column_name from table_name Where condition(s);
View Answer

SELECT MIN(column_name) FROM TABLE_NAME WHERE condition(s);

9. What is the syntax to get maximum value of a field?
a) Select large(column_name) from table_name Where condition(s);
b) Select column_name from table_name Where max (column_name);
c) Select max(column_name) from table_name Where condition(s);
d) Select max( ) column_name from table_name Where condition(s);
View Answer

SELECT MAX(column_name) FROM TABLE_NAME WHERE condition(s);

10. Max and MIN functions cannot be used at a time in a single Select statement.
a) True
b) False
View Answer

SELECT MAX (column_name), MIN(column_name)
FROM TABLE_NAME
WHERE condition(s);

Sanfoundry Global Education & Learning Series – SQL.

To practice all areas of SQL, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]