Refer to the exhibit. An engineering supervisor at a water utility asks the GIS analyst to find all pipes that are less than 10 inches in diameter. The analyst prepares a Select By Attribute query on the geodatabase feature class: Diameter 0 and

Question

Refer to the exhibit.  An engineering supervisor at a water utility asks the GIS analyst to find all pipes that are less than 10 inches in diameter. The analyst prepares a Select By Attribute query on the geodatabase feature class: Diameter < 10 When validating this SQL query, the analyst gets the error: "There was an error with the expression." What is invalid about the query?
A) Field name must be in enclosed in brackets: [Diameter] 
B) Field name must be in enclosed in single quotes: 'Diameter' 
C) Diameter is a text field but is using a numeric comparison 
D) Query should include Diameter > 0 and < 10

Quizplus · Accepted Answer

The Answer of Refer to the exhibit.  An engineering supervisor at a water utility asks the GIS analyst to find all pipes that are less than 10 inches in diameter. The analyst prepares a Select By Attribute query on the geodatabase feature class: Diameter < 10 When validating this SQL query, the analyst gets the error: "There was an error with the expression." What is invalid about the query?
A) Field name must be in enclosed in brackets: [Diameter] 
B) Field name must be in enclosed in single quotes: 'Diameter' 
C) Diameter is a text field but is using a numeric comparison 
D) Query should include Diameter > 0 and < 10

Refer to the Exhibit