MySQL Questions and Answers – The group by & having Clause

This set of MySQL Multiple Choice Questions & Answers (MCQs) focuses on “The group by & having Clause”.

1. What is the meaning of “GROUP BY” clause in Mysql?
a) Group data by column values
b) Group data by row values
c) Group data by column and row values
d) None of the mentioned
View Answer

2. Which clause is similar to “HAVING” clause in Mysql?
a) SELECT
b) WHERE
c) FROM
d) None of the mentioned
View Answer

3. What is the meaning of “HAVING” clause in Mysql?
a) To filter out the row values
b) To filter out the column values
c) To filter out the row and column values
d) None of the mentioned
View Answer

4. “COUNT” keyword belongs to which categories in Mysql?
a) Aggregate functions
b) Operators
c) Clauses
d) All of the mentioned
View Answer

5. Which among the following belongs to an “aggregate function”?
a) COUNT
b) UPPER
c) LOWER
d) All of the mentioned
View Answer

6. Which of the following belongs to an “aggregate function”?
a) COUNT
b) SUM/AVG
c) MIN/MAX
d) All of the mentioned
View Answer

7. Which clause is used with an “aggregate functions”?
a) GROUP BY
b) SELECT
c) WHERE
d) Both GROUP BY and WHERE
View Answer

8. What is the significance of the statement “GROUP BY d.name” in the following MySQL statement?

SELECT d.name, COUNT (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.name

a) Aggregation of the field “name” of both table
b) Aggregation of the field “name” of table “department”
c) Sorting of the field “name”
d) None of the mentioned
View Answer

9. What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement?

SELECT d.name, COUNT (emp_id) emp_no
FROM department d INNER JOIN Employee e
ON d.dept_id=e.emp_id
GROUP BY d.name
HAVING COUNT (emp_id)>2

a) Filter out all rows whose total emp_id below 2
b) Selecting those rows whose total emp_id>2
c) Filter out all rows whose total emp_id below 2 & Selecting those rows whose total emp_id>2
d) None of the mentioned
View Answer

Sanfoundry Global Education & Learning Series – MySQL Database.

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