Multiple choice practice questions for CIS

Multiple choice practice questions for CIS - 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 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. 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 D. Physical view 5. What are characteristics or properties of an entity called? A. Attributes B. Fields C. Columns D. All of the above 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 7. 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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 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 C. Increased information redundancy D. Increased information integrity 10. What refers to how well a system can adapt to increased demands? A. Scalability 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 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 13. 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 14. Which of the following is true in regards to the elimination of redundant information? A. Uses additional hard disk space
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 for CIS - 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