> > >

Access MCQs

This question is based upon the figure shown below
See the image above. How would you filter the table so that it returns names of only those students whose last name begins with A, O or Y?

Select lastname from students where lastname like '[A,O, Y]*'

Select lastname from students where lastname like '*[A, O, Y]'

Select lastname from students where lastname not like '*[A, O, Y]'

Select lastname from students where lastname not like '[A,O, Y]*'

Select lastname from students where lastname='A' or lastname='O'or lastname='Y'

Answer

Correct Answer:

Select lastname from students where lastname like '[A,O, Y]*'

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Access Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it