1. Which among the following is not a “query clause”?
   

1. 1. FROM

   
   
   

   2. ALTER

   
   
   

   3. MODIFY

   
   
   

   4. WHERE

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   Modify is not a clause, it just used with clause Alter.

---

2. Which clause is used to “sort the rows of the final result set by one or more columns”?
   

1. 1. ORDER BY

   
   
   

   2. HAVING

   
   
   

   3. FROM

   
   
   

   4. WHERE

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   ORDER BY

---

---

3. Which clause is used to “Modify the existing field of the table”?
   

1. 1. MODIFY

   
   
   

   2. SELECT

   
   
   

   3. FROM

   
   
   

   4. ALTER

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   ALTER

---

4. Which clause is used to “filter out unwanted Groups”?
   

1. 1. SELECT

   
   
   

   2. WHERE

   
   
   

   3. FROM

   
   
   

   4. HAVING

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   SELECT

---

---

5. “MODIFY” is used with which “Query clause”?
   

1. 1. ORDER BY

   
   
   

   2. WHERE

   
   
   

   3. ALTER

   
   
   

   4. FROM

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Modify is not a clause, it just used with clause Alter.

---