Multiple choice practice questions (answers)

Multiple choice practice questions (answers) - Chapter 07...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 07 Storing Organizational Information-Databases 1. Which of the following types of information can be found in a database? A. Inventory B. Transactions C. Employees D. All of the above (CORRECT ANSWER) 2. Which of the following database structures offers a flexible way of representing objects and their relationships? A. Hierarchical database B. Network database (CORRECT ANSWER) 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 (CORRECT ANSWER) B. Logical view C. Attribute D. Physical view 4. In the relational database model, what are characteristics or properties of an entity? A. Entity B. Logical view C. Attribute (CORRECT) D. Physical view 5. What are characteristics or properties of an entity called? A. Attributes B. Fields C. Columns D. All of the above (CORRECT) 6. 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(CORRECT ANSWER)? 7. What is a primary key? A. A field (or group of fields) that uniquely identifies a given entity in a table (CORRECT ANSWER) B. A primary key of one table that appears as an attribute in another table and acts to provide a logical
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
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 8. 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 (CORRECT ANSWER) C. Characteristics or properties of an entity D. A field (or group of fields) that uniquely identifies a given attribute in a table 9. All of the following are advantages of database-stored information, except: A. Increased flexibility B. Increased performance (CORRECT ANSWER) C. Increased information redundancy D. Increased information integrity 10. What refers to how well a system can adapt to increased demands? A. Scalability (CORRECT ANSWER) B. Performance C. Redundancy D. Information integrity 11. Which of the following measures how quickly a system performs a certain process or transaction? A. Scalability (CORRECT ANSWER) B. Performance C. Redundancy D. Information integrity 12. 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 (CORRECT ANSWER) 13. What is the primary problem with redundant information? A. It is difficult to determine which values are the most current
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 14

Multiple choice practice questions (answers) - Chapter 07...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online