1. Which clause is mandatory with clause “SELECT” in Mysql?
   

1. 1. WHERE

   
   
   

   2. FROM

   
   
   

   3. Both WHERE and FROM

   
   
   

   4. CREATE

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   “SELECT” clause cannot be used without clause “FROM”.

---

2. 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.

---

---

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

   SELECT Employee_id, FirstName, LastName
   FROM Employee
   WHERE Employee_id=1;
   

1. 1. Show all columns and rows

   
   
   

   2. Shows only columns Employee_id

   
   
   

   3. Show only columns(Employee_id, FirstName, LastName) 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 are belong to Employee_id=1.

---

4. Find the error?
   

   SELECT *;
   

1. 1. No table mentioned

   
   
   

   2. Depends

   
   
   

   3. No Error

   
   
   

   4. All of these

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   “SELECT” clause cannot be used without clause “FROM”.

---

---

5. 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 ().

---