The answers are given as A and E for this question. Shouldn't it be B and D. Select all pattern values of a LIKE expression that would identify a word starting with a �J� and having �on� as the last two characters.
A. �J%on_� B. �J*on%� C. �J%on*� D. �J_on%� E. �J%_on_�
% means more than 0 characters, i.e. any characters that can be appended at the end of the searching keyword.
_ means exactly 1 character, and thus, there is only 1 character that can be appended at the end of the searching keyword.
But I guess the question has some problems. What is the meaning of the last 2 characters? I feel it is meaning the 2nd last and last characters are 'on', and thus, it should be 'None of the above'.
Actually, % means 0 or more characters, that is % can stand for an empty sequence of characters (EJB spec section 11.2.7.9).
As for the wording you are totally correct, it should say something like "...having 'on' as the last two but one characters" I apologize, this is my mistake since it is one of the questions I wrote for Whizlabs SCBCD exam simulator I'll tell them to correct that. Thanks for pointing this out
Post by:autobot
We can fix it! We just need some baling wire, some WD-40, a bit of duct tape and this tiny ad:
a bit of art, as a gift, that will fit in a stocking