GIS Exam 2 with 100% Correct
Solutions
Suppose you have downloaded a GIS data set. The data set has the length measure in
meters instead of feet. Describe the steps you will follow to add a length measure in feet
to the data set. - ANS-First, a new field called feet must be defined and added to the
data set. Then the new field is populated with the values calculated from meters.
Write a valid SQL expression to select cities between 1000 and 10,000 people using a
field called POP2002 - ANS-SELECT *FROM cities WHERE "POP2000" > 1000 AND
"POP2000" < 10000
Suppose you have downloaded a GIS data set. The feature attribute table has a field
that contains values such as 12, 13, and so on. How can you find out in ArcGIS if these
values represent numbers or text strings? - ANS-Correct In ArcCatalog, right-click the
data set in the catalog tree and select properties. Click on the Fields tab, and read the
Data Type of the field.
Provide an example of a nonspatial attribute table - ANS-[An example of a nonspatial
attribute table is a table that contains soil attributes but does not have direct access to
the geometry of soil polygons.]
Which of the following operations can create new attribute data from existing data? -
ANS--data classification
-data query
-data computation
-Correct: only a and c
-only b and c
In GIS, a table that is specifically associated with a spatial data layer is referred to as
a(n) table. - ANS--standalone
-spatial
-Correct: attribute
-source
When performing a spatial query in GIS, which of the following is a type of spatial
condition/criteria that could be used? - ANS--intersect
-touch the boundary of
-are completely within
-Correct: all of the above
, Describe the difference between attribute table and standalone table - ANS-Tables
associated with spatial data sets are called attribute tables and contain records, one of
each feature in the data set. Standalone tables are not associated with map feature
List the type of data sources from which tables may display data - ANS-Lots of tabular
data sources, including dBase files, INFO files, geodatabases, SQL queries, or comma-
delimited files.
What is the cardinality of each of the following relationships? - ANS-•Students to college
classes - many to many
•students to governors - many to one
•students to grades - many to many
•counties to states - many to one
Choose the best filed for each of the following types of data in a geodatabase - ANS--
Population of countries in the world: Long
-Precipitation in inches: Short
-Number of counties in a state: Short
-Highway name: Text
-Distances between US cities, in meters: Long
-Birthdays: Date
In GIS, which of the following would most likely be the easiest way to determine whether
or not the habitat area of a particular species is within a certain distance of an oil
pipeline? - ANS-A. attribute query
B. SQL statement
C. join
D. Correct: spatial query
Selecting objects from one layer based on their spatial relationship with another layer
describes a: - ANS--spatial join
-spatial selection
-Correct: spatial query
-spatial attribute
Which of the following queries will select all housing parcels classified as "residential"
(from a layer called PARCELS) that are also considered to be "seasonal" homes (from a
layer called STATUS)? - ANS--Correct: PARCELS = "residential" AND STATUS =
"seasonal"
-PARCELS = "residential" OR STATUS = "seasonal"
-PARCELS = "residential" XOR STATUS = "seasonal"
-PARCEL <> "residential" AND STATUS <> "seasonal"
Which of the following queries will select all counties that have a population with more
than 100000 persons (from a layer called POP) as well as all counties that have more
Solutions
Suppose you have downloaded a GIS data set. The data set has the length measure in
meters instead of feet. Describe the steps you will follow to add a length measure in feet
to the data set. - ANS-First, a new field called feet must be defined and added to the
data set. Then the new field is populated with the values calculated from meters.
Write a valid SQL expression to select cities between 1000 and 10,000 people using a
field called POP2002 - ANS-SELECT *FROM cities WHERE "POP2000" > 1000 AND
"POP2000" < 10000
Suppose you have downloaded a GIS data set. The feature attribute table has a field
that contains values such as 12, 13, and so on. How can you find out in ArcGIS if these
values represent numbers or text strings? - ANS-Correct In ArcCatalog, right-click the
data set in the catalog tree and select properties. Click on the Fields tab, and read the
Data Type of the field.
Provide an example of a nonspatial attribute table - ANS-[An example of a nonspatial
attribute table is a table that contains soil attributes but does not have direct access to
the geometry of soil polygons.]
Which of the following operations can create new attribute data from existing data? -
ANS--data classification
-data query
-data computation
-Correct: only a and c
-only b and c
In GIS, a table that is specifically associated with a spatial data layer is referred to as
a(n) table. - ANS--standalone
-spatial
-Correct: attribute
-source
When performing a spatial query in GIS, which of the following is a type of spatial
condition/criteria that could be used? - ANS--intersect
-touch the boundary of
-are completely within
-Correct: all of the above
, Describe the difference between attribute table and standalone table - ANS-Tables
associated with spatial data sets are called attribute tables and contain records, one of
each feature in the data set. Standalone tables are not associated with map feature
List the type of data sources from which tables may display data - ANS-Lots of tabular
data sources, including dBase files, INFO files, geodatabases, SQL queries, or comma-
delimited files.
What is the cardinality of each of the following relationships? - ANS-•Students to college
classes - many to many
•students to governors - many to one
•students to grades - many to many
•counties to states - many to one
Choose the best filed for each of the following types of data in a geodatabase - ANS--
Population of countries in the world: Long
-Precipitation in inches: Short
-Number of counties in a state: Short
-Highway name: Text
-Distances between US cities, in meters: Long
-Birthdays: Date
In GIS, which of the following would most likely be the easiest way to determine whether
or not the habitat area of a particular species is within a certain distance of an oil
pipeline? - ANS-A. attribute query
B. SQL statement
C. join
D. Correct: spatial query
Selecting objects from one layer based on their spatial relationship with another layer
describes a: - ANS--spatial join
-spatial selection
-Correct: spatial query
-spatial attribute
Which of the following queries will select all housing parcels classified as "residential"
(from a layer called PARCELS) that are also considered to be "seasonal" homes (from a
layer called STATUS)? - ANS--Correct: PARCELS = "residential" AND STATUS =
"seasonal"
-PARCELS = "residential" OR STATUS = "seasonal"
-PARCELS = "residential" XOR STATUS = "seasonal"
-PARCEL <> "residential" AND STATUS <> "seasonal"
Which of the following queries will select all counties that have a population with more
than 100000 persons (from a layer called POP) as well as all counties that have more
