Which SQL statement do you use?

The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that
contain ‘SA_’ in the JOB_ID column. Which SQL statement do you use?

A.
SELECT employee_id, last_name, job_id FROM employees WHERE job_id = ‘%SA_’;

B.
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE
‘%SA\_’ ESCAPE ‘\’;

C.
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE
‘%SA_’;

D.
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_’
ESCAPE “\”;

Explanation: