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.
Missing backslash characters in question:
SELECT part_code
FROM spares
WHERE part_code LIKE ‘%\%_WQ12%’ ESCAPE ‘\’
There are something wrong when edit content. Thanks Oscar. Fixed.
admin, is there any chance you have this iz0-051 in pdf format ?
i would like to study it in an offline device ( i.e. phone, ipod )
thanks in advance ( I dunno if this reply was duplicated, my apoligize if it was )
Why D is the right answer. Can someone explain it for me? Thanks.
‘%\%_WQ12%’ ESCAPE ‘\’
so we look for strings like:
– zero or more characters at the begining
– then % sign
– then 1 character
– then string WQ12
– and again zero or more characters at the end.
thanks Justyna