To display the names of employees that are not assigned to a department. Evaluate this SQL statement: SELECT last_name, first_name FROM employee WHERE dept_id = NULL; Which change should you make to achieve the desired result?
Answer options
A
Change the = operator to IS NULL in the WHERE clause.
B
Add NOT in front of NULL.
C
Change = to <> NULL.
D
No change needed; the query is correct.
Correct answer: Change the = operator to IS NULL in the WHERE clause.
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.