11. Which among the following can also be included with “SELECT” clause while writing query in Mysql?
    

1. 1. User defined functions

   
   
   

   2. Literals

   
   
   

   3. Expressions

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   “SELECT clause” can also include Literals like ‘ACTIVE’, Expressions like emp_id*314, Built_in functions like UPPER ().

---

12. Is there any error in executing the following query?
    

    SELECT Student_id, ‘ACTIVE’,
    Student_id * 3.145,
    UPPER (LastName)
    FROM Student;
    

1. 1. NO

   
   
   

   2. Depends on condition

   
   
   

   3. Yes

   
   
   

   4. Undefined behaviour

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   “SELECT clause” includes the following: Literals like ‘ACTIVE’, Expressions like Student_id*314, Built_in functions like UPPER ().

---

---

13. Which Clause is used to select a particular table in Mysql?
    

1. 1. ALTER

   
   
   

   2. FROM

   
   
   

   3. WHERE

   
   
   

   4. SELECT

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   FROM

---

14. What is the need of “column Aliases” in “SELECT” clause?
    

1. 1. To overwrite the existing column name in result set

   
   
   

   2. To modify the column name while using literals, Expression, built_in functions with “SELECT clause

   
   
   

   3. To assign a new label to the column in result set

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   “Column Aliases” are used to assign a new label to the columns in the result set without actually changing the column name.

---

---

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

    SELECT Student_id,
    ‘ACTIVE’ STATUS,
    Student_id * 3.14 Student_pi,
    UPPER (LName) Last_Name
    FROM Student;
    

1. 1. Error

   
   
   

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

   
   
   

   3. Student_id, Status, Student_pi, Last_Name

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Status, Student_pi, Last_Name are “column aliases”.

---