Question Number 43 of the Diagnostic Exam of WhizLabs preparation kit.
According to the WhizLabs, the correct answer is C.
Can someone tell me why the answer B is wrong?
SELECT d
FROM Dept d LEFT JOIN FETCH d.employees
WHERE d.department_no = 1
[A] From the above query only employees of department no 1 will be retrieved.
[B] From the above query those departments will be retrieved which has employee and have department_no not equals to 1.
[C] This will retrieve all the departments, which has department_no equals to 1. It will also retrieve the associated employees with the set of departments.
[D] This is an invalid query.
According to the WhizLabs, the correct answer is C.
Can someone tell me why the answer B is wrong?