Question: Answer the following questions. (a) For a user operation, how transaction will be processed? Draw a state diagram and discuss the typical states that a

 Answer the following questions. (a) For a user operation, how transaction

Answer the following questions.

(a) For a user operation, how transaction will be processed? Draw a state diagram and discuss the typical states that a transaction goes through during execution. (b) What is the transaction commit points, and why are they important? What is the system log used for? What are the typical kinds of records in a system log for instructions? (c) Consider the below mention Schedule & items ( X=20,Y=30 as initial values), Answer the following, (i). Derive the possible values of data items X and Y, for both T1 T2 and T2 T1. (ii). Verify, whether above mention schedule follows 2phase locking protocol? If yes explain the order and data item values for the sequence, otherwise justify your

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!