Quiz 7

T/F? Both Vector and Raster data models can have attribute tables.

True

T/F? Conducting Joins and Relates between two tables is temporary.

True

T/F? In a GeoDatabase a Key Field is a system created and managed field that stores unique key values; also called feature ID.

True

When conducting a join between two tables, the field types of the join fields must match.

True

Normalization in DBMS is:

a process of decomposition by which a large table, with all the attribute table, is split into smaller tables that can be distributed to multiple databases.

Spatial queries can be used to select features based on their shape and location as it relates to other features, graphics, or selection geometries. Those relationships include: Intersect, ___________________, containment, and/or proximity.

adjacency

The foreign key ALWAYS connects to the:

primary key (the one with the FID column).

A transaction manager, in an database management system, ___________

takes requests from higher tiers and searches the relevant portions of the database to identify the requested data.

Select the two advantage that Relational Database Management Systems (RDBMS) provide.

-Each table can be prepared, maintained, and edited separately for other tables -The tables can remain separate until they are needed to be linked in a query or an application

What are the primary functions of a database management system?

-Enable User, Multi-User, Application, and multi-application data access -Manage security and access -Optimize data structure to improve performance

What are the available types of fields in ArcGIS? (Pick all the apply)

-Short Integer -Long Integer -Binary Long Object (BLOB) -Single-precision floating point number (float) -Double-precision floating point number (float) -String

What is a one-to-one relationship between tables?

A record in a table matching a record in another table based on a common key.

A data model's conceptual structure is often represented as:

A schema, which is a compact graphical representation of the entities, their attributes, and the relationships between them.

What are the main components of a database management system?

Data Items and Attributes

How is attribute data stored in table format?

Each row (or record) is one observation or a spatial feature with each column (of field) representing on variable.

T/F? Additional information (such as additional fields) cannot be added to a table after it has been created.

False

T/F? In ArcGIS Pro can field types be changed once they are created?

False

A _____ appends one table to another.

Join

Keys (such as foreign or primary) allow the user to:

Link records in multiple tables together based on a shared attribute value.

SQL, the standard language for retrieving and updating information in a database, stands for what?

Structured Query Language