GIS Final based On Final Exam Review - Questions With
Accurate Answers
flat file database Right Ans - stores rows of information in a text or binary
file, not efficient for search and query
Hierarchical database Right Ans - has multiple files, each of which contains
different records and fields (parent-child linked through a key,
fixed/predefined relationship), efficient for specific queries
relational database Right Ans - Widely used in GIS: has multiple tables
stored as files. the relationships are not defined ahead of time, the user can
associate two tables if they share a common field called a join (same as
Hierarchical, but flexible)
Join table/source table v.s target/destination table Right Ans - The table
that contains the information to be appended is the join table while the table
that receives the appended information is called the target table
unmatched records in joins-<null> values Right Ans - when a target record
has no match in the join table
Rule of Joining Right Ans - each record in the destination table must have
one and only one matching record in the source table
cardinality that follow the rule of joining Right Ans - one-to-one and many-
to-one
relate v.s. join Right Ans - relates used in the case of one to many because it
can not be joined and displayed as a single table. tables remain separate but
are linked together
object id (gdb) Right Ans - unique integer managed by the software to
identify the record
add join vs join field Right Ans - add join is temporary, and joins a layer to
another layer or table based on a common field. Join field is permanent and
joins the contents of a table to another based on a common attribute field
, topology - adjacency Right Ans - sharing boundary
Schema Right Ans - the structure of a table including its fields, definitions,
and domains
Digitizing Right Ans - the process of creating GIS data from another
secondary source
Topology: Connectivity Right Ans - attachment.connectedness between
features
topology: intersection/overlap Right Ans - cover all/in part
logical consistency Right Ans - (ideal/real world) eg. street/waterline
actually connect
query Right Ans - extract a subset of a feature class or table based on a
condition set by the user
logical operators Right Ans - State=NJ or GPA>3.0
SQL Right Ans - how expressions are executed
Clause builder vs SQL edit/viewer mode Right Ans - Clause builder is an
easy intuitive way to enter expressions, but SQL is sometime convenient or
necessary to write expressions directly
Order of precedence Right Ans - Boolean operators have no order of
precedence, evaluated from left to right (A AND B=B ANB A)
spatial operators Right Ans - intersect, contains/within (feature is
inside/outside)
proximity Right Ans - within a specified distance
Buffer Right Ans - finds areas within the specified distance of a set features
Why dissolve buffers? Right Ans - To not count the same area twice
Accurate Answers
flat file database Right Ans - stores rows of information in a text or binary
file, not efficient for search and query
Hierarchical database Right Ans - has multiple files, each of which contains
different records and fields (parent-child linked through a key,
fixed/predefined relationship), efficient for specific queries
relational database Right Ans - Widely used in GIS: has multiple tables
stored as files. the relationships are not defined ahead of time, the user can
associate two tables if they share a common field called a join (same as
Hierarchical, but flexible)
Join table/source table v.s target/destination table Right Ans - The table
that contains the information to be appended is the join table while the table
that receives the appended information is called the target table
unmatched records in joins-<null> values Right Ans - when a target record
has no match in the join table
Rule of Joining Right Ans - each record in the destination table must have
one and only one matching record in the source table
cardinality that follow the rule of joining Right Ans - one-to-one and many-
to-one
relate v.s. join Right Ans - relates used in the case of one to many because it
can not be joined and displayed as a single table. tables remain separate but
are linked together
object id (gdb) Right Ans - unique integer managed by the software to
identify the record
add join vs join field Right Ans - add join is temporary, and joins a layer to
another layer or table based on a common field. Join field is permanent and
joins the contents of a table to another based on a common attribute field
, topology - adjacency Right Ans - sharing boundary
Schema Right Ans - the structure of a table including its fields, definitions,
and domains
Digitizing Right Ans - the process of creating GIS data from another
secondary source
Topology: Connectivity Right Ans - attachment.connectedness between
features
topology: intersection/overlap Right Ans - cover all/in part
logical consistency Right Ans - (ideal/real world) eg. street/waterline
actually connect
query Right Ans - extract a subset of a feature class or table based on a
condition set by the user
logical operators Right Ans - State=NJ or GPA>3.0
SQL Right Ans - how expressions are executed
Clause builder vs SQL edit/viewer mode Right Ans - Clause builder is an
easy intuitive way to enter expressions, but SQL is sometime convenient or
necessary to write expressions directly
Order of precedence Right Ans - Boolean operators have no order of
precedence, evaluated from left to right (A AND B=B ANB A)
spatial operators Right Ans - intersect, contains/within (feature is
inside/outside)
proximity Right Ans - within a specified distance
Buffer Right Ans - finds areas within the specified distance of a set features
Why dissolve buffers? Right Ans - To not count the same area twice
