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

    SELECT *
    FROM employee
    WHERE (title=’HEAD TELLER’) OR (start_date > 2013-01-24);
    

1. 1. All rows belong to table employee

   
   
   

   2. All columns and rows belong to table employee

   
   
   

   3. All columns but only those rows which contain ‘HEAD TELLER’ as a “title” OR start_date are greater than 2013-01-24

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   “WHERE” clause is used to filter out unwanted rows therefore in above query only those rows will be selected which contain title as ‘HEAD TELLER’ OR start_date is greater than 2013-01-24.

---

17. What will be the output of the query given below?
    

    SELECT Id, FirstName, LastName
    FROM Student
    WHERE title=’Monitor’;
    

1. 1. Columns mention with “SELECT” clause and only those rows which contain ‘Monitor’ as a “title”

   
   
   

   2. All columns

   
   
   

   3. Only those columns which are mention with “SELECT” clause

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   “WHERE” clause is used to filter out unwanted rows and “SELECT” clause is used to select columns from table.

---

---

18. What will be the output of the query given below?
    

    SELECT Student_id, FirstName, LastName
    FROM Student
    WHERE title=’Monitor’ AND start_date=2017-02-25;
    

1. 1. Only those columns which are mention with “SELECT” clause

   
   
   

   2. Columns mention with “SELECT” clause and only those rows which contain ‘Monitor’ as a “title” and start_date as 2017-02-25

   
   
   

   3. All columns

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   “WHERE” clause is used to filter out unwanted rows and “SELECT” clause is used to select columns from table.

---

19. What will be the output of the query given below?
    

    SELECT emp_id, fname, lname
    FROM employee
    WHERE title='Manager’ AND start_date > 2016-03-20;
    

1. 1. Columns mention with “SELECT” clause and only those rows which contain ‘Manager’ as a “title” and start_date > 2016-03-20

   
   
   

   2. All columns

   
   
   

   3. Only those columns which are mention with “SELECT” clause

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   Columns mention with “SELECT” clause and only those rows which contain ‘Manager’ as a “title” and start_date > 2016-03-20

---

---

20. Which Clause is used to select a particular row from the set of row in an existing table?
    

1. 1. FROM

   
   
   

   2. ALTER

   
   
   

   3. WHERE

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   WHERE

---