Chapter 7: Databases & Data Warehouse

1. Which of the following database structures stores information in a tree-like structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships?

• A. Hierarchical database

• B. Network database

• C. Relational database model

• D. All of the above

2. Which of the following database structures offers a flexible way of representing objects and their relationships?

• A. Hierarchical database

• B. Network database

• C. Relational database model

• D. All of the above

3. In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

• A. Entity

• B. Entity class

• C. Attribute

• D. Attribute class

4. Why do relational databases use primary keys and foreign keys?

• A. To create a database

• B. To create physical relationships

• C. To create logical relationships

• D. All of the above

5. What is a primary key?

• A. A field (or group of fields) that uniquely identifies a given entity in a table

• B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables

• C. Characteristics or properties of an entity

• D. A field (or group of fields) that uniquely identifies a given attribute in a table

6. What is a foreign key?

• A. A field (or group of fields) that uniquely identifies a given entity in a table

• B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables

• C. Characteristics or properties of an entity

• D. A field (or group of fields) that uniquely identifies a given attribute in a table

7. All of the following are advantages of database-stored information, except:

• A. Increased flexibility

• B. Increased performance

• C. Increased information redundancy

• D. Increased information integrity

8. Which of the following is incorrect in reference to a database?

• A. Can be relational or network

• B. Information is accessed by logical structure

• C. Information is accessed by physical structure

• D. Users can access different views of information

9. What is the physical view of information?

• A. Deals with the physical storage of information on a storage device such as a hard disk

• B. Deals with the logical storage of information on a storage device such as a hard disk

• C. Focuses on how users logically access information to meet their particular business needs

• D. Focuses on how users physically access information to meet their particular business needs

10. Which of the following is correct in reference to a database?

• A. A database can support only one logical view

• B. A database can support many physical views

• C. A database can support many logical views

• D. A database can support up to three logical views