1. What is the significance of the statement “HAVING COUNT (emp_id)>2” in the given query?
   

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

1. 1. Selecting those rows whose total emp_id > 2

   
   
   

   2. Filter out all rows whose total emp_id below 2 & Selecting those rows whose total emp_id > 2

   
   
   

   3. Filter out all rows whose total emp_id below 2

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   “HAVING” clause are worked similar as “WHERE” clause.

---

2. What is the significance of the statement “GROUP BY d.name” in the given query?
   

   SELECT p.name, COUNT (emp_id) Per_no
   FROM Person p INNER JOIN Employee em
   ON p.per_id=em.emp_id
   GROUP BY p.name
   

1. 1. Aggregation of the field “name” of table “department”

   
   
   

   2. Sorting of the field “name”

   
   
   

   3. Aggregation of the field “name” of both table

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   “GROUP BY” clause s used for aggregation of field.

---

---

3. Which clause is used with an “aggregate functions”?
   

1. 1. SELECT

   
   
   

   2. WHERE

   
   
   

   3. GROUP BY

   
   
   

   4. Both SELECT and WHERE

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   “GROUP BY” is used with aggregate functions.

---

4. Which of the following belongs to an “aggregate function”?
   

1. 1. MIN/MAX

   
   
   

   2. COUNT

   
   
   

   3. SUM/AVG

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   MIN/MAX, COUNT and SUM/AVG are belongs to an “aggregate function”.

---

---

5. What is the meaning of “GROUP BY” clause in Mysql?
   

1. 1. Group data by column and row values

   
   
   

   2. Group data by column values

   
   
   

   3. Group data by row values

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   Group data by column values

---