Which query is used to delete employee records whose age is greater than 55?
Answer options
A
DELETE FROM employee WHERE age > 55;
B
DROP FROM employee WHERE age > 55;
C
TRUNCATE employee WHERE age > 55;
D
REMOVE FROM employee WHERE age > 55;
Correct answer: DELETE FROM employee WHERE age > 55;
Explanation
Quick AnswerThe correct answer is DELETE FROM employee WHERE age > 55; because it directly addresses the core logic of Database Management.
DELETE with a WHERE clause filters which rows are removed.