1. In the following query “person_id” can be
   

   SELECT Emp_id, fname,Lname, Birth_date FROM Employee
      WHERE Emp_id=101;
   

1. 1. Only Attribute but not a primary Key

   
   
   

   2. Only Primary Key

   
   
   

   3. Primary Key or any other Attribute

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Primary Key or any other Attribute

---

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

---

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

---

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

---

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

---