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

1. 1. True AND false= false

   
   
   

   2. False AND false= false

   
   
   

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

---

57. Which of the following operators is/are used in “Condition Evaluation”?
    

1. 1. OR

   
   
   

   2. NOT

   
   
   

   3. AND

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   All of above

---

---

58. What is the use of “VIEW” in Mysql?
    

1. 1. To hide the complexity of the database

   
   
   

   2. To simplify complexity of database design

   
   
   

   3. To hide columns from the users

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: D

   All of above

---

59. Is there any error in this query?
    

    SELECT emp.emp_id, emp.fname, emp.lname, dep.name FROM employee AS emp INNER JOIN department AS dep ON emp.dept_id = emp.dept_id;
    

1. 1. YES

   
   
   

   2. DEPEND

   
   
   

   3. NO

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   There will be no error in the query, as table name “employee” is replaced by ‘e’ and table name “department” is replaced by ‘d’ by using “AS” keyword.

---

---

60. Is there any error in this query?
    

    SELECT emp.emp_id, 
     emp.fname, emp.lname, dep.name
    FROM employee emp INNER JOIN department dep
    ON emp.dept_id = emp.dept_id;
    

1. 1. YES

   
   
   

   2. DEPEND

   
   
   

   3. NO

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   There will be no error in the query, as table name “employee” is replaced by ‘e’ and table name “department” is replaced by‘d’.

---