Database Systems Design Implementation and Management 12Th Edition By Carlos Coronel -Test Bank

1. The practical significance of taking the logical view of a database is that it serves as a reminder of the simple file concept of data storage. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Moderate REF: ...

1. The practical significance of taking the logical view of a database is that it serves as a reminder of the simple file concept of data storage. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Moderate REF: p.73 NAT: BUSPROG: Analytic STATE: DISC: Information Technology KEY: Bloom’s:Comprehension TOP: A Logical View of Data 2. You can think of a table as a persistent representation of a logical relation. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Easy REF. p.74 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s:Knowledge TOP: A Logical View of Data 3. The order of the rows and columns is important to the DBMS. 1. True 2. False ANSWER: False PTS: 1 DIF: Difficulty: Easy REF: p.74 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s: Knowledge TOP: A Logical View of Data 4. Character data can contain any character or symbol intended for mathematical manipulation. 1. True 2. False ANSWER: False PTS: 1 DIF: Difficulty: Easy REF: p.75 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s:Knowledge TOP: A Logical View of Data 5. The row’s range of permissible values is known as its domain. 1. True 2. False ANSWER: False PTS: 1 DIF: Difficulty: Easy REF: p.75 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s Knowledge TOP: A Logical View of Data 6. The idea of determination is unique to the database environment. 1. True 2. False ANSWER: False PTS: 1 DIF: Difficulty: Moderate REF: p.76 NAT: BUSPROG: Analytic STATE: DISC: Information Technology KEY: Bloom’s Comprehension TOP: Keys 7. Only a single attribute, not multiple attributes, can define functional dependence. 1. True 2. False ANSWER: False PTS: 1 DIF: Difficulty: Easy REF: p.76 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s:Knowledge TOP: Keys 8. If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A). 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Moderate REF: p.77 NAT: BUSPROG: Analytic STATE: DISC: Information Technology KEY: Bloom’s Comprehension TOP: Keys 9. A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Easy REF: p.78 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s:Knowledge TOP: Keys 10. Depending on the sophistication of the application development software, nulls can create problems when functions such as COUNT, AVERAGE, and SUM are used. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Easy REF: p.78 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s:Knowledge TOP: Keys 11. RDBMSs enforce integrity rules automatically. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Easy REF: p.80 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s: Knowledge TOP: Integrity Rules 12. Relational algebra defines the theoretical way of manipulating table contents using relational operators. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Easy REF: p.82 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s:Knowledge TOP: Relational Algebra 13. The SELECT operator yields a vertical subset of a table. 1. True 2. False ANSWER: False PTS: 1 DIF: Difficulty: Easy REF: p.83 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s: Knowledge TOP: Relational Algebra 14. The DIFFERENCE operator subtracts one table from the other. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Easy REF: p.85 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s: Knowledge TOP: Relational Algebra 15. In a natural join, the column on which the join was made occurs twice in the new table. 1. True 2. False ANSWER: False PTS: 1 DIF: Difficulty: Easy REF: p.88 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s:Knowledge TOP: Relational Algebra 16. The DIVIDE operation uses one singlecolumn table (e.g., column “a”) as the divisor and one twocolumn table (e.g., columns “a” and “b”) as the dividend. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Easy REF: p.90 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s:Knowledge TOP: Relational Algebra 17. A data dictionary is sometimes described as “the database designer’s database” because it records the design decisions about tables and their structures. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Easy REF: p.91 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s: Knowledge TOP: The Data Dictionary and the System Catalog 18. The onetomany (1:M) relationship is easily implemented in the relational model by putting the foreign key of the “1” side in the table of the “many” side as a primary key. 1. True 2. False ANSWER: False PTS: 1 DIF: Difficulty: Moderate REF: p.94 NAT: BUSPROG: Analytic STATE: DISC: Information Technology KEY: Bloom’s Comprehension TOP: Relationships within the Relational Database 19. As rare as 1:1 relationships should be, certain conditions absolutely require their use. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Easy REF: p.96 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s: Knowledge TOP: Relationships within the Relational Database 20. Each table in a relational database must have a primary key. 1. True 2. False ANSWER: True PTS: 1 DIF: Difficulty: Easy REF: p.20 NAT: BUSPROG: Technology STATE: DISC: Information Technology KEY: Bloom’s: Knowledge TOP: A Logical View of Data