This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 178 Chapter 17 3. Read all (records on all) pages in file F 1. 4. Read pages P 500 through P 520. 5. Read pages P 10 through P 980. 6. Read all pages in F 1 and (based on the values read) modify 10 pages. 7. Delete record P 1200 : 98. (This is a blind write.) 8. Delete the first record from each page. (Again, these are blind writes.) 9. Delete all records. Answer 17.11 The answer to each question is given below. 1. IS on D; IS on F2; IS on P1200; S on P1200:5. 2. IS on D; IS on F2; IS on P1200, S on 1201 through 1204, IS on P1205; S on P1200:98/99/100, S on P1205:1/2. 3. IS on D; S on F1 4. IS on D; IS on F1; S on P500 through P520. 5. IS on D; S on F1 (performance hit of locking 970 pages is likely to be higher than other blocked transactions). 6. IS and IX on D; SIX on F1. 7. IX on D; IX on F2; X on P1200. (Locking the whole page is not necessary, but it would require some reorganization or compaction.) 8. IX on D; X on F1 and F2. (There are many ways to do this, there is a tradeoff between overhead and con- currency.) 9. IX on D; X on F1 and F2. Exercise 17.12 Suppose that we have only two types of transactions, T 1 and T 2....
View Full Document
This note was uploaded on 01/17/2012 for the course EGN 4302 taught by Professor Dr.vishak during the Fall '12 term at University of Central Florida.
- Fall '12