Chapter09Review

Chapter09Review - Database Processing, Ninth Edition...

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

View Full Document Right Arrow Icon
Database Processing, Ninth Edition CHAPTER 9 Managing Multi-User Databases True-False Questions 1. Database administration tasks have to be performed for single-user, personal databases. Answer: True Level: hard Page: 300 2. Database administration is more important but less difficult in multi-user database systems than in single-user database systems. Answer: False Level: moderate Page: 300 3. In general, the overall responsibility of the DBA is to facilitate the development and use of the database system. Answer: True Level: easy Page: 301 4. The DBA has to find a balance between the conflicting goals of maximizing availability of the database to users and protecting the database. Answer: True Level: moderate Page: 301 5. The DBA is responsible for managing changes to the database structure, but is rarely involved in the original design of the structure. Answer: False Level: moderate Page: 301 6. Changes in the database structure usually involve only one application. Answer: False Level: hard Page: 301 7. One important reason for documenting changes to the database structure is for diagnosing errors. Answer: True Level: easy Page: 301 8. Concurrency control measures are taken to ensure that one user’s work has absolutely no influence on another user’s work. Answer: False Level: moderate Page: 302 9 - 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
Chapter 9 - Managing Multi-User Databases 9. A transaction is a group of alternative database actions from which the database can choose to perform only one of them. Answer: False Level: easy Page: 303 10. “Resource locking” is one remedy to the lost update problem. Answer: True Level: moderate Page: 306 11. “Explicit locks” are locks that are placed automatically by the DBMS. Answer: False Level: easy Page: 307 12. Locks with large granularity are easy for the DBMS to administer but frequently cause conflicts. Answer: True Level: moderate Page: 307 13. In general, the boundaries of a transaction should correspond to the boundaries of the database view it is processing. Answer: True Level: hard Page: 308 14. Resource locking must be carefully planned because most DBMS products cannot detect a deadlock condition. Answer: False Level: moderate Page: 309 15. Resources are locked for a shorter amount of time with pessimistic locking because the transaction is pre-processed. Answer: False Level: easy Page: 309 16. In general, optimistic locking is the preferred technique for Internet databases. Answer: True Level: hard Page: 309 17. A "dirty read" happens when one transaction reads a changed record that has not been committed to the database. Answer: True Level: hard Page: 312 18. “Repeatable Reads” isolation is the most restrictive level of isolation. Answer:
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.

This note was uploaded on 04/28/2011 for the course IT 101 taught by Professor K during the Spring '11 term at Richmond.

Page1 / 15

Chapter09Review - Database Processing, Ninth Edition...

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