nerdexam
Esri

EADA10 · Question #8

Given a layer called Counties with the following relevant attributes: - POP2008 - POP2000 - STATE_NAME Esri EADA10 Exam What is the correct WHERE clause syntax for Select by attributes tool that…

The correct answer is A. ("Counties.POP2008" > 50000 AND < 100000) AND "Countries.STATE_NAME" = `Florida'. See the full explanation below for the reasoning.

Question

Given a layer called Counties with the following relevant attributes:

  • POP2008
  • POP2000
  • STATE_NAME

Esri EADA10 Exam What is the correct WHERE clause syntax for Select by attributes tool that should be used to find all the Counties with a population greater than 50000 and less than 100000 in state of Florida in year 2008?

Options

  • A("Counties.POP2008" > 50000 AND < 100000) AND "Countries.STATE_NAME" = `Florida'
  • B("Counties.POP2008" > 50000 AND "Counties.POP2000" < 100000) AND "Counties.STATE_NAME" = `Florida'
  • C("Counties.POP2008" > 50000 AND "Counties.POP2008" < 100000 AND "Counties.STATE" `Florida')
  • D("Counties.POP2008" > 50000 AND "Counties.POP2008" < 100000) AND "Counties.STATE_NAME" = `Florida'

How the community answered

(23 responses)
  • A
    83% (19)
  • B
    4% (1)
  • C
    9% (2)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full EADA10 Practice