1. What will be the output of the following query?
   

   SELECT First_name
   FROM Employee
   WHERE emp_id != 6 OR emp_id IS  NULL;
   

1. 1. Only those names whose emp_id is not equal to 6

   
   
   

   2. Only those names whose emp_id is equal to 6

   
   
   

   3. Only those names whose emp_id is not equal to 6 or emp_id with NULL values

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Only those names whose emp_id is not equal to 6 or emp_id with NULL values

---

2. What will be the output of the following query?
   

   SELECT First_name
   FROM Employee
   WHERE emp_id != 6;
   

1. 1. Only those names whose emp_id is equal to 6

   
   
   

   2. Only those names whose emp_id is not less than 6

   
   
   

   3. Only those names whose emp_id is not equal to 6

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Only those names whose emp_id is not equal to 6

---

---

3. What will be the output of the following query?
   

   SELECT *
   FROM Employee
   WHERE emp_id = NULL;
   

1. 1. No output

   
   
   

   2. Only those columns whose emp_id is NULL

   
   
   

   3. Only those columns whose emp_id is not NULL

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: A

   An expression can never be equate to NULL that is why there will be no output.

---

4. What will be the output of the following query?
   

   SELECT * 
   FROM Student
   WHERE id IS NULL;
   

1. 1. No output

   
   
   

   2. Only those columns whose id is NULL

   
   
   

   3. Only those columns whose id is not NULL

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: C

   Only those columns whose id is not NULL

---

---

5. What will be the output of the following query?
   

   SELECT *
   FROM Student
   WHERE id IS NULL;
   

1. 1. No output

   
   
   

   2. Only those columns whose id is NULL

   
   
   

   3. Only those columns whose id is not NULL

   
   
   

   4. All of above

   
   
   

   5. None of these

   
   
   

---

1. View Hint View Answer Discuss in Forum

   NA

   Correct Option: B

   Only those columns whose id is NULL

---