Attribute Data Management Quiz

What does attribute data describe?

• Characteristics of the map feature

• Spatial data

• Database designs

• Map symbols

What is a feature attribute table?

• A table that stores spatial data

• A table that stores attribute data

• A table that must have a unique label ID

• A table that contains both spatial and attribute data

What is the purpose of a database management system (DBMS)?

• To store all attributes in a single table

• To provide tools for data input, search, retrieval, manipulation, and output

• To avoid redundant data in the table

• To maintain and update data effectively

What are the types of attribute data defined by measurement scale?

• Nominal, Ordinal, Interval, Ratio

• Character string, Integers, Real numbers, Dates

• Binary Large Object, Nominal, Ordinal

• Interval, Ratio, Nominal, Character string

What is normalization in database design?

• The process of breaking down a table into small tables

• The process of combining multiple tables into one

• The process of creating a flat file database

• The process of establishing relationships between tables

What are the four types of relationships in a relational database?

• One-to-one, One-to-many, Many-to-one, Many-to-many

• Flat file, Hierarchical, Network, Relational

• Primary key, Foreign key, Unique key, Composite key

• Nominal, Ordinal, Interval, Ratio

What is the difference between a join and a relate in database operations?

• Join combines tables; relate establishes a logical connection

• Join keeps tables separate; relate combines them

• Join is used for one-to-one relationships; relate for many-to-many

• Join is a type of normalization; relate is not

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

• Sequential Query Language