How to retrieve department_id column without any duplication from employee relation?
Answer options
A
SELECT DISTINCT department_id FROM employee;
B
SELECT department_id FROM employee;
C
SELECT UNIQUE department_id FROM employee;
D
SELECT TOP 1 department_id FROM employee;
Correct answer: SELECT DISTINCT department_id FROM employee;
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.