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
Exact match uses = operator.