MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 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” ?$ |
| A. | SELECT * FROM Persons WHERE FirstName=’a’ |
| B. | SELECT * FROM Persons WHERE FirstName LIKE ‘a%’ |
| C. | SELECT * FROM Persons WHERE FirstName LIKE ‘%a’ |
| D. | SELECT * FROM Persons WHERE FirstName=’%a%’ |
| Answer» D. SELECT * FROM Persons WHERE FirstName=‚Äö√Ñ√∂‚àö√ë‚àö¬•%a%‚Äö√Ñ√∂‚àö√ë‚àö¬• | |