Final Exam

Question 1

What do attribute tables do?

Answer 1

Store data associated with a spatial feature class.

Question 2

What do standalone tables do?

Answer 2

Store tabular data from any source.

Question 3

What are some common sources of standalone tables?

Answer 3

Excel, text files, CSV files, and database files are all common sources.

Question 4

When working with XY (point) data in ArcGIS, what does X represent?

Answer 4

Longitude

Question 5

When working with XY (point) data in ArcGIS, what does Y represent?

Answer 5

Latitude

Question 6

When naming fields in Excel for use in ArcGIS, you can only use what characters?

Answer 6

Letters, numbers, and the underscore.

Question 7

When naming fields in Excel for use in ArcGIS, what does the field name have to start with?

Answer 7

A letter (not a number or an underscore).

Question 8

What is a Boolean operator?

Answer 8

A logical operator used in a Boolean expression, such as AND, OR, NOT, or XOR.

Question 9

What is NOT a Boolean operator?

Answer 9

Expressions like “at least”

Question 10

What does the Boolean AND do?

Answer 10

Specifies a combination of conditions (a AND b = the intersection of those two things)

Question 11

What does the Boolean OR do?

Answer 11

Specifies a list of alternative conditions (a OR b must be true = everything within those two)

Question 12

What is select by location designed for?

Answer 12

Spatial data query

Question 13

What is select by attribute designed for?

Answer 13

Attribute data query

Question 14

What Boolean operator is used for the intersect tool?

Answer 14

AND

Question 15

What Boolean operator is used for the union tool?

Answer 15

OR

Question 16

What is the target layer in select by location queries?

Answer 16

The layer containing the features being selected.

Question 17

What is the source layer in select by location queries?

Answer 17

The layer containing the features being compared to.

Question 18

In an attribute table, what are the rows called?

Answer 18

Records.

Question 19

In an attribute table, what are the columns called?

Answer 19

Fields.

Question 20

What is the target table in a join?

Answer 20

The table that receives the information.

Question 21

What is the rule of joining?

Answer 21

Each record in the target table must match one (and only one) record in the joining table. Therefore, only one-to-one and many-to-one joins will work.

Question 22

What are the three naming rules of creating fields?

Answer 22

The name must be no more than 64 characters long, follow ArcGIS rules (letters, numbers, and underscore), and start with a letter.

Question 23

In the attribute table what are the rows and columns called?

Answer 23

Records and fields.

Question 24

What do attribute queries test for?

Answer 24

Table values (such as “population > 400”)

Question 25

What do spatial queries test for?

Answer 25

Spatial relationships (such as located within a state, or parcels in a flood plain)

Question 26

What is an interactive query?

Answer 26

The user visually identifies and manually selects the desired features or records in an attribute table.

Question 27

What are arithmetic operators?

Answer 27

+ - x ^ operators that act on numbers and their numeric values.

Question 28

What are logical operators?

Answer 28

> < = operators that test conditions and return a true or false.

Question 29

What are Boolean operators?

Answer 29

AND OR XOR NOT operators that test pairs of conditions and return a true or false.

Question 30

What are spatial operators?

Answer 30

Operators that test spatial relationships such as proximity.

Question 31

What programming language to attribute queries use?

Answer 31

Structured Query Language (SQL)

Question 32

What are three basic operators that test spatial relationships?

Answer 32

Intersect, contains/within, and proximity

Question 33

Which allows for a shared boundary if a feature is on the edge of a containing feature? Contains or completely contains?

Answer 33

Contains