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

---

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

    SELECT *
    FROM Student
    WHERE title=’Monitor’;
    

1. 1. All columns don’t belong to table Student

   
   
   

   2. columns and rows belong to table Student

   
   
   

   3. All columns but only those rows which contain ‘Monitor’ as a “title”

   
   
   

   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 ‘Monitor’.

---

---

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

    SELECT *
    FROM Student
    WHERE (title=’Monitor’) AND (start_date=2019-01-25);
    

1. 1. All columns but only those rows which contain ‘Monitor’ as a “title” and 2019-01-25 as a “start_date”

   
   
   

   2. All rows belong to table Student

   
   
   

   3. All columns and rows belong to table Student

   
   
   

   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 therefore in above query only those rows will be selected which contain title as ‘Monitor’ and start_date 2019-01-25.

---

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

    SELECT *
    FROM Army
    WHERE (title=’Sergeant’) OR (start_date=1995-03-20);
    

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 ‘Sergeant as a “title” or 1995-03-20 as a “start_date”

   
   
   

   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 ‘Sergeant’ or start_date 1995-03-20.

---

---

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

    SELECT *
    FROM Army
    WHERE (title=’Sergeant ’) AND (start_date > 1995-03-20);
    

1. 1. All columns but only those rows which contain ‘Sergeant ’ as a “title” and start_date are greater than 1995-03-20

   
   
   

   2. All rows belong to table employee

   
   
   

   3. All columns and rows belong to table employee

   
   
   

   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 therefore in above query only those rows will be selected which contain title as ‘Sergeant ’ and start_date is greater than 1995-03-20.

---