1. Which among the following belongs to an “aggregate function”?
   

1. 1. LOWER

   
   
   

   2. UPPER

   
   
   

   3. COUNT

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   LOWER

---

2. “COUNT” keyword belongs to which categories in Mysql?
   

1. 1. Clauses

   
   
   

   2. Aggregate functions

   
   
   

   3. Operators

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   Aggregate functions

---

---

3. What is the meaning of “HAVING” clause in Mysql?
   

1. 1. To filter out the row and column values

   
   
   

   2. To filter out the column values

   
   
   

   3. To filter out the row values

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   To filter out the row values

---

4. Which clause is similar to “HAVING” clause in Mysql?
   

1. 1. FROM

   
   
   

   2. SELECT

   
   
   

   3. WHERE

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   “WHERE” is also used to filter the row values in Mysql.

---

---