16. If id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?
    

    SELECT id
    FROM student
    ORDER BY id ASC;
    

1. 1. {2, 1, 3, 4, 6, 7, 9}

   
   
   

   2. {9, 7, 6, 4, 3, 1, 2}

   
   
   

   3. {1, 2, 3, 4, 6, 7, 9}

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   “ASC” clause sort the emp_id in the ascending order.

---

17. Find odd one out?
    

1. 1. ASC

   
   
   

   2. ORDER BY

   
   
   

   3. DESC

   
   
   

   4. GROUP BY

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   “ORDER BY”, “DESC”, “ASC” are related to sorting whereas “GROUP BY” is not related to sorting.

---

---

18. Is there any error in the following query?
    

    SELECT emp_id, title, start_date, First_name, fed_id
    FROM Employee
    ORDER BY RIGHT (fed_id, 3);
    

1. 1. No error

   
   
   

   2. Depends

   
   
   

   3. Yes

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   “ORDER BY” clause can be used with expression such as fed_id, which is a social security no like 111, 111, 111 therefore we sort it taking only three digits from right.

---

19. Is there any error in the following query?
    

    SELECT emp_id, title, start_date, fname, fed_id
    FROM Employee
    ORDER BY LEFT (fed_id, 5);
    

1. 1. Depends

   
   
   

   2. Yes

   
   
   

   3. No error

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   “ORDER BY” clause can be used with expression such as fed_id which is a social security no like 111, 111, 111 therefore we sort it taking only 5 digits from left.

---

---