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 ‘\’;
D is correct, tested.
SELECT ‘true’ FROM dual WHERE ‘A%_WQ123’ LIKE ‘%\%_WQ12%’ ESCAPE ‘\’; -> true
SELECT ‘true’ FROM dual WHERE ‘A%BWQ123’ LIKE ‘%\%_WQ12%’ ESCAPE ‘\’; -> true
SELECT ‘true’ FROM dual WHERE ‘AB_WQ123’ LIKE ‘%\%_WQ12%’ ESCAPE ‘\’; -> (-)