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
Quick AnswerThe correct answer is DELETE FROM Employee WHERE emp_id = 1207; because it directly addresses the core logic of Database Management.
DELETE with a WHERE clause removes specific rows matching the condition.