WHERE lname LIKE ‘_a%e%’;
A. All employees whose last name start with any letter but second letter should be ‘a’.
B. All employees whose last name start with any letter but contain at least one ‘e’ in his name.
C. All employees whose last name should have letter ‘a’ in second position and at least one ‘e’ in his name.
D. All of the above
Answer:A
WHERE lname LIKE ‘_a%e%’;
A. All employees whose last name start with any letter but second letter should be ‘a’. B. All employees whose last name start with any letter but contain at least one ‘e’ in his name. C. All employees whose last name should have letter ‘a’ in second position and at least one ‘e’ in his name. D. All of the above
Explanation: None.