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_�
Actually, % means 0 or more characters, that is % can stand for an empty sequence of characters (EJB spec section 220.127.116.11).
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