Which of the following queries will select all counties that have a population with more than 100,000 persons (from a layer called POP)as well as all counties that have more than 100,000 housing units (from a layers called HOUSES)? A)POP 100000 AND HOUSES 100000 B)(POP AND HOUSES) 100000 C)POP 100000 OR HOUSES 100000 D)POP 100000 XOR HOUSES =

Question

Which of the following queries will select all counties that have a population with more than 100,000 persons (from a layer called POP)as well as all counties that have more than 100,000 housing units (from a layers called HOUSES)?
A)POP > 100000 AND HOUSES > 100000
B)(POP AND HOUSES)> 100000
C)POP > 100000 OR HOUSES > 100000
D)POP > 100000 XOR HOUSES =< 100000

Quizplus · Accepted Answer

The query should select all counties that have a population with more than 100,000 persons OR all counties that have more than 100,000 housing units. Therefore, the correct logical operator to use is OR. Choice A uses AND, which would only select counties that meet both qualifications, not one or the other. Choice B does not use the correct logical operator and would not result in the desired selection. Choice D uses the XOR operator, which would exclude any counties that meet both qualifications, resulting in an incomplete selection.

Which of the Following Queries Will Select All Counties That