Esri Exam EADP19-001 Topic 1 Question 63 Discussion

An ArcGIS has created a definition query on a parcel feature in a personal geodatabase to only show areas classified as residential. The user's company has decided to update all personal geodatabase to file geodatabases.

When the ArcGIS user updates the source data to point to the parcel feature class in the file geodatabase they receive the following error.

"One or more layers failed to draw:

Parcel: An invalid SQL statement was used. [Select Shape FROM Parcel WHERE [Parcel] B residential]

Parcel: An invalid SQL statement was used"

What is the correct SQL statement for the file geodatabase?