1

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

Correct Answer: SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

Make the most of this question

This page focuses on one Database Management System (DBMS) question from Engineering. After checking the answer, return to the topic list to practice more or run a timed set.

Database Management System (DBMS) MCQ: With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”? | Extra Education