OCP CBT Question 526

Please solve the following question.

You need to retrieve the `first_name`, `last_name`, and `email` for all employees whose `last_name` starts with the letter 'K'. Which SQL statement will achieve this?

EMPLOYEES Table Sample Data
FIRST_NAME LAST_NAME             EMAIL
---------- --------------------- -------------------------
Steven     King                  SKING
Neena      Kochhar               NKOCHHAR
Lex        De Haan               LDEHAAN
David      Kemper                DKEMPER
Nancy      Greenberg             NGREENBE
Daniel     Katz                  DKATZ

SELECT first_name, last_name, email FROM employees WHERE last_name = 'K%';

SELECT first_name, last_name, email FROM employees WHERE last_name LIKE 'K%';

SELECT first_name, last_name, email FROM employees WHERE last_name STARTS WITH 'K';

SELECT first_name, last_name, email FROM employees WHERE SUBSTR(last_name, 1, 1) = 'K';