OCP-1Z0-051-V9.02-58题

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

PART_CODE      

A%_WQ123      

A%BWQ123

AB_WQ123

Evaluate the following query:

SQL> SELECT part_code           

FROM spares           

WHERE part_code LIKE '%\ %_WQ12%' ESCAPE '\'; 都有% _代替一个字符

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.

Answer: D

答案解析：

WHERE part_code LIKE '%\ %_WQ12%' ESCAPE '\';

ESCAPE 将\为转义字符，故\后面的%原型输出，而%后面的_,在SQL语句里代表一个替换字符。

故结果A%_WQ123 和A%BWQ123