Database and Page Ref

Database Processing, 13e (Kroenke/Auer)
Chapter 9: Managing Multiuser Databases

1) Database administration tasks have to be performed for single-user, personal databases.
Answer: TRUE
Diff: 3 Page Ref: 396

2) Database administration is more important but less difficult in multiuser database systems than in single-user database systems.
Answer: FALSE
Diff: 2 Page Ref: 396

3) In general, the overall responsibility of the DBA is to facilitate the development and use of the database system.
Answer: TRUE
Diff: 1 Page Ref: 396

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
Diff: 2 Page Ref: 396

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
Diff: 2 Page Ref: 396

6) Changes in the database structure usually involve only one application.
Answer: FALSE
Diff: 3 Page Ref: 396

7) The database is most vulnerable to failure after a change to its structure.
Answer: TRUE
Diff: 3 Page Ref: 397

8) One important reason for documenting changes to the database structure is for diagnosing errors.
Answer: TRUE
Diff: 1 Page Ref: 397

9) Concurrency control measures are taken to ensure that one user's work has absolutely no influence on another user's work.
Answer: FALSE
Diff: 2 Page Ref: 397

10) A transaction is sometimes called atomic because it is performed as a unit.
Answer: TRUE
Diff: 1 Page Ref: 398
11) A transaction is a series of actions to be taken on the database such that either all of them are performed successfully or none of them is performed at all.
Answer: TRUE
Diff: 1 Page Ref: 398

12) A transaction is a group of alternative database actions, from which the database can choose to perform only one of them.
Answer: FALSE
Diff: 1 Page Ref: 398

13) The size of a lock is referred to