Homework_9_solution

Homework_9_solution - Name: _Solution_ Homework 9 ISE 382...

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

View Full Document Right Arrow Icon
Name: ___Solution____ Homework 9 ISE 382 Introduction to Computer Systems 15 points Due Date – Friday April 28th Answer questions 9.3, 9.7, 9.8, 9.10, 9.11, 9.41, 9.42, 9.45, 9.46, 9.47 on pages 321 and 322 of the Textbook. 9.3 List seven important DBA tasks. (1) Managing database structure (2) Controlling concurrent processing (3) Managing processing rights and responsibilities (4) Developing database security (5) Providing for database recovery (6) Managing the DBMS (7) Maintaining the data repository 9.7 Explain the trade-off that exists in concurrency control. High level of concurrency control is easier for the DBMS to administer but causes poor throughput. A low level of concurrency control is more difficult to administer for the DBMS, but provides better throughput. 9.8 Define an atomic transaction and explain why atomicity is important. An atomic transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all, in which case the database remains unchanged. Such a transaction is sometimes called a Logical Unit of Work because it is performed as a unit. It is important because the database should maintain
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Homework_9_solution - Name: _Solution_ Homework 9 ISE 382...

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

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