{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Ch10Questions - 1 Assume that the following sequence of...

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

View Full Document Right Arrow Icon
1. Assume that the following sequence of events occurs: T1 = access data items X and Y T2 = access data items Y and X This is called a(n) ____. a. inconsistent state b. failed transaction c. deadly embrace d. rollback 2. If any of the SQL statements in a transaction fail, the entire transaction is ____ to the original database state that existed before the transaction started. 3. The scheduler facilitates data ____ to ensure that two transactions do not update the same data element at the same time. 4. When a program is abnormally terminated, the equivalent of a ____ command occurs. 5. If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent. a. atomicity b. consistency c. isolation d. durability 6. In a ____ lock, the DBMS will lock an entire disk page. 7. A(n)____ guarantees exclusive use of a data item to a current transaction.
Image of page 1

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

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

{[ snackBarMessage ]}