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;
Explanation
DELETE with a WHERE clause removes specific rows matching the condition.