Question

Which of the following query clauses would match attributes of the city names "New York" and "Newbury" in an attribute table if they were in a field called "city_name"?

a) city_name = 'New York' OR city_name = 'Newbury'
b) city_name LIKE 'New%'
c) city_name IN ('New York', 'Newbury')
d) city_name = 'New York' AND city_name = 'Newbury'

Answer 1

The query clauses matching 'New York' and 'Newbury' are b) city_name LIKE 'New%' and c) city_name IN ('New York', 'Newbury') with the latter being the most concise and precise option.

Step-by-step explanation:

The correct answer to which query clauses would match attributes of the city names "New York" and "Newbury" in an attribute table in a field called "city_name" is both b) city_name LIKE 'New%' and c) city_name IN ('New York', 'Newbury').

• a) city_name = 'New York' OR city_name = 'Newbury' would also work, but it is not as concise as option c.
• Option d) city_name = 'New York' AND city_name = 'Newbury' is incorrect because it implies that city_name can be both 'New York' and 'Newbury' at the same time, which is not possible.
• Option b) would also match any other city names that start with 'New', which may or may not be desired based on the context. If only 'New York' and 'Newbury' should match, then option c) is the best choice.