M.C.A. SEM. II MID SEM EXAMINATION MAY 2010
Sub: 620006 DBMS-II
DATE: 03/05/2010 TIME: 45 Minutes MARKS: 20
| Q.1 | Attempt any two of the following | 14 | |
| | (a) | What is transaction? Discuss ACID properties of transaction? | |
| | (b) | What is Concurrency Control? List and explain problem of Concurrency? | |
| | (c) | Describe shadow paging recovery technique in detail? | |
| Q.2 | Differentiate any two of the following | 6 | |
| | (a) | Immediate Update Vs Deferred Update Technique | |
| | (b) | Binary lock Vs Shared Lock | |
| | (c) | Timestamp ordering technique Vs Optimistic Concurrency tech. | |
| | | | |
0 comments:
Post a Comment