6. What will be the output of a query given below?
   

   SELECT  * FROM Employee
   WHERE Employee_id=1;
   

1. 1. Show all columns and rows

   
   
   

   2. Shows only columns Employee_id

   
   
   

   3. Show all columns but only those rows which belongs to Employee_id=1

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Clause “WHERE” is also used, which tell the compiler to show only that rows which belong to Employee_id=1.

---

7. What will be the output of a query given below?
   

   SELECT *
   FROM Employee;
   

1. 1. Show all columns of table “Employee”

   
   
   

   2. Show all rows and columns of table “Employee”

   
   
   

   3. Show all rows of table “Employee”

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   “SELECT” clause is used to show all rows or columns.

---

---

8. What is the meaning of “SELECT” clause in Mysql?
   

1. 1. Show me all columns

   
   
   

   2. Show me all rows

   
   
   

   3. Show me all Columns and rows

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Show me all Columns and rows

---

9. Which of the following clause is evaluated in the last by database server?
   

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: B

   “SELECT” clause is used to show all rows or columns therefore it evaluated at last.

---

---

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

    SELECT USER (),
    VERSION (), DATABASE ();
    

1. 1. Depends

   
   
   

   2. Yes, “FROM” is not used

   
   
   

   3. No

   
   
   

   4. Undefined behaviour

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Clause “FROM” is not necessary when we used “Built in” function with “SELECT” clause.

---