Deck 2: How to Use Tables, Attributes, and Queries in Arcgis Pro

Question 1

In ArcMap, the spatial and non-spatial information about a layer is stored in its:

A) Attribute Table
B) Spatial Field
C) Excel file
D) Parcel database

Answer 1

A

Question 2

The format used in an SQL query in ArcGIS is:

A) Field, Operator, Value
B) Field, Operator, Record(s)
C) Record(s), Operator, Value
D) Field, Value, Record(s)

Answer 2

A

Question 3

A connector such as =, >, or <= used in an SQL query in ArcGIS is referred to as a:

A) Conditional operator
B) Fixed operator
C) Relational operator
D) Connecting operator

Answer 3

C

Question 4

A hyperlink in ArcGIS describes which of the following?

A) A file that can be downloaded from the Internet into ArcMap
B) A file that is joined to another geospatial layer or attribute table
C) A process used to connect geospatial features to other items, such as documents, files, photos, URLs, or scripts
D) A process that is used to insert a photo into a geodatabase

Question 5

A map of the locations of car race winners displayed by their placement ranking is an example of which kind of data?

A) Nominal
B) Ordinal
C) Interval
D) Ratio

Question 6

A map of the locations of the Great Lakes labeled with the name of each lake is showing which kind of data?

A) Nominal
B) Ordinal
C) Interval
D) Ratio

Question 7

GIS data that are descriptive and not location-based are:

A) Geospatial
B) Coordinate
C) Fixed
D) Non-Spatial

Question 8

Celsius temperature is an example of which kind of data?

A) Nominal
B) Ordinal
C) Interval
D) Ratio

Question 9

The columns of an attribute table represent:

A) Objects
B) Points
C) Records
D) Fields

Question 10

A map of the locations of California four-year universities displayed by the average tuition costs is an example of which kind of data?

A) Nominal
B) Ordinal
C) Interval
D) Ratio

Question 11

How are U.S, Census Bureau data used in GIS?

A) TIGER/Line files come pre-loaded with all available attribute data.
B) Attribute data are acquired separately from Cartographic Boundary Files and then must be joined to those files.
C) Three different files must be linked together-TIGER/Line, Cartographic Boundary, and American Factfinder datasets
D) All GIS data (geospatial and attribute) are available from the U.S. Census Bureau's American Factfinder

Question 12

What is the result of using AND in a compound query of two statements?

A) The results of the query will be the records that meet both query statements.
B) The results of the query will be the records that meet either one of the query statements.
C) The results of the query will be the records that meet either one of the query statements but not the records that meet both statements.
D) The results of the query will be the records that do not meet either one of the query statements.

Question 13

The rows of an attribute table represent:

A) Fields
B) Records
C) Layers
D) Attributes

Question 14

Your phone number is an example of which kind of data?

A) Nominal
B) Ordinal
C) Interval
D) Ratio

Question 15

What is the result of using OR in a compound query of two statements?

A) The results of the query will be the records that meet both query statements.
B) The results of the query will be the records that meet either one of the query statements.
C) The results of the query will be the records that meet either one of the query statements but not the records that meet both statements.
D) The results of the query will be the records that do not meet either one of the query statements.

Question 16

When a single record is linked to another single record in a join, what kind of join has occurred?

A) Many-to-one join
B) One-to-many join
C) One-to-all join
D) One-to-one join

Question 17

The total number of relational operators used in a simple query is:

A) Zero
B) One
C) Two
D) Three

Question 18

In terms of joining tables, what does a key represent?

A) The table that the data is being joined from
B) The single record being used to join the tables
C) The field that the two tables have in common
D) The internal relation in the database between the two tables