51. What will be the result of the following query?
    

    WHERE TITLE=’teller’ OR start_date=’2008-02-02’
    

1. 1. The employee is something other than a teller but was employed prior to 2008

   
   
   

   2. The employee is a teller and was employed prior to 2008

   
   
   

   3. The employee is a teller and was employed after February 2, 2008

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   The operator “OR” will evaluate all result which satisfy either side of the query.

---

52. What will be the result of the following query?
    

    WHERE TITLE= ‘teller’ AND start_date < ’2007-01-01’
    

1. 1. Only tellers who began working for the bank prior to 2007 will not be included

   
   
   

   2. Only tellers who began working for the bank prior to 2007 will be included

   
   
   

   3. Any employee who is either not a teller or began working for the bank in 2007 or later will be removed from consideration

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   The operator “AND” will evaluate only those sets which satisfy both side.

---

---

53. Which of the following statements is/are correct?
    

1. 1. NOT(false AND false)=true

   
   
   

   2. NOT (true AND false)= true

   
   
   

   3. NOT(true AND true) =false

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   All of above

---

54. Which of the following statements is/are correct?
    

1. 1. NOT=false

   
   
   

   2. NOT(true)=false

   
   
   

   3. NOT(false)=true

   
   
   

   4. Both NOT(true)=false and NOT(false)=true

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   Both NOT(true)=false and NOT(false)=true

---

---

55. Which of the following statements is/are correct?
    

1. 1. True OR false= true

   
   
   

   2. False OR false= false

   
   
   

   3. True OR true =true

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   All of above

---