Consider a database organized in terms of the following hierarchy of objects: The database itself is an
Question:
Multiple-granularity locking is used, with S, X, IS, IX and SIX locks, and databaselevel, file-level, page-level and record-level locking. For each of the following operations, indicate the sequence of lock requests that must be generated by a transaction that wants to carry out (just) these operations:
1. Read record P1200: 5.
2. Read records P1200: 98 through P1205: 2.
3. Read all (records on all) pages in file F1.
4. Read pages P500 through P520.
5. Read pages P10 through P980.
6. Read all pages in F1 and (based on the values read) modify 10 pages.
7. Delete record P1200: 98. (This is a blind write.)
8. Delete the first record from each page. (Again, these are blind writes.)
9. Delete all records.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff
Question Posted: