Select the suitable option for retrieving all the employees whose last name is "kumar"?
Answer options
A
SELECT * FROM employee WHERE last_name = 'kumar';
B
SELECT * FROM employee WHERE last_name LIKE 'kumar%';
C
SELECT * FROM employee WHERE last_name LIKE '%kumar';
D
SELECT * FROM employee WHERE last_name != 'kumar';
Correct answer: SELECT * FROM employee WHERE last_name = 'kumar';
Explanation
Quick AnswerThe correct answer is SELECT * FROM employee WHERE last_name = 'kumar'; because it directly addresses the core logic of Database Management.
Exact match uses = operator.