NEW
Font size
WorksheetsChapter 7: Databases & Data Warehouse
Total questions: 20
Worksheet time: 11mins
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
11. What refers to how well a system can adapt to increased demands?
A. Scalability
B. Performance
C. Redundancy
D. Information integrity
12. Which of the following measures how quickly a system performs a certain process or transaction?
A. Scalability
B. Performance
C. Redundancy
D. Information integrity
13. What is information redundancy?
A. Duplication of information
B. Storing the same information in multiple places
C. Storing duplicate information in multiple places
D. All of the above
14. What is the primary problem with redundant information?
A. It is difficult to determine which values are the most current
B. It is often inconsistent
C. It is difficult to determine which values are the most accurate
D. All of the above
15. What are the rules that help ensure the quality of information?
A. Information integrity
B. Integrity constraints
C. Relational integrity constraints
D. Business-critical integrity constraints
16. What are rules that enforce basic and fundamental information-based constraints?
A. Information integrity
B. Integrity constraint
C. Business-critical integrity constraint
D. Relational integrity constraint
17. Which of the following is a valid type of integrity constraint?
A. Relational-critical integrity constraint
B. Business integrity constraint
C. Relational integrity constraint
D. Business-critical integrity constraint
18. What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
A. Relational integrity constraint
B. Business-critical integrity constraint
C. Information-critical integrity constraint
D. None of the above
19. What is an interactive Web site kept constantly updated and relevant to the needs of its customers through the use of a database?
A. Data-provided Web site
B. Data-driven Web site
C. Information-provided Web site
D. Information-driven Web site
20. Which of the following is not an advantage to a data-driven Web site?
A. Development
B. Minimizing human error
C. Increasing update costs
D. More efficient
