Which statement is true regarding the outcome of the ab…

The PART_CODE column in the SPARES table contains the following list of values:

Which statement is true regarding the outcome of the above query?

A.
It produces an error.

B.
It displays all values.

C.
It displays only the values A%_WQ123 and AB_WQ123 .

D.
It displays only the values A%_WQ123 and A%BWQ123 .

E.
It displays only the values A%BWQ123 and AB_WQ123.

Explanation:
Combining Wildcard Characters
The % and _ symbols can be used in any combination with literal characters. The example in the slide displays
the names of all employees whose last names have the letter “o” as the second character.
ESCAPE Identifier
When you need to have an exact match for the actual % and _ characters, use the ESCAPE identifier. This
option specifies what the escape character is. If you want to search for strings that contain SA_, you can use
the following SQL statement:
SELECT employee_id, last_name, job_id
FROM employees WHERE job_id LIKE ‘%SA\\_%’ ESCAPE ‘\\’;