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.
答案:D
解析:ESCAPE 后面的字符为转义字符,%\%_WQ12%,因此第一个%为模糊匹配然后是转义字符\,转义的是%,因此选择带有%号的
所以,排除ABCE,因此选择D,"_"为匹配任意一个字符
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.
答案:D
解析:ESCAPE 后面的字符为转义字符,%\%_WQ12%,因此第一个%为模糊匹配然后是转义字符\,转义的是%,因此选择带有%号的
所以,排除ABCE,因此选择D,"_"为匹配任意一个字符