Which query will delete all the data in the Employee table that belongs to the employee id 1207?
Answer options
A
DELETE FROM Employee WHERE emp_id = 1207;
B
DROP FROM Employee WHERE emp_id = 1207;
C
TRUNCATE Employee WHERE emp_id = 1207;
D
REMOVE FROM Employee WHERE emp_id = 1207;
Correct answer: DELETE FROM Employee WHERE emp_id = 1207;
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.