16. What will be the result of the query given below?
    

    SELECT Person_id,
    ‘ACTIVE’ AS STATUS,
    Person_id * 3.14 AS Person_pi,
    UPPER (LName) AS Last_Name
    FROM Person;
    

1. 1. Error

   
   
   

   2. Person_id, ACTIVE, Person_id * 314, UPPER(LName)

   
   
   

   3. Person_id, Status, Person_pi, Last_Name

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Status, Person_pi, Last_Name are “column aliases” and Keyword “AS” is optional.

---

17. Which Keyword is used to remove duplicate rows in result set?
    

1. 1. MODIFY

   
   
   

   2. DISTINCT

   
   
   

   3. DISTINCTS

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   DISTINCT

---

---

18. If in Table “account”, a column “Customer_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?
    

    SELECT DISTINICT Customer_id
    FROM account;
    

1. 1. {1, 2, 3, 5, 6, 7, 8}

   
   
   

   2. { }

   
   
   

   3. {1, 2, 2, 3, 3, 5, 6, 7, 8, 8}

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   DISTINICT keyword will remove the duplicate entries in the result set.

---

19. If in Table “Customer”, a column “Customer_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?
    

    SELECT DISTINICT emp_id
    FROM employee;
    

1. 1. {1,2,3,5,6,7,8}

   
   
   

   2. { }

   
   
   

   3. {1,2,2,3,3,5,6,7,8,8}

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   DISTINICT keyword will remove the duplicate entries in the result set.

---

---

20. Which among the following is an optional Keyword?
    

1. 1. AS

   
   
   

   2. ALL

   
   
   

   3. Both AS and ALL

   
   
   

   4. DISTINICTS

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   “AS” and “ALL” are optional.

---