Register

transaction control

2,751 views
2 votes
2 votes
In basic time stamp ordering W-time stamp (Q) denotes the largest time stamp of any transaction that has executed write-(Q) successfully.Suppose that we define W-time stamp(Q) as the most recent transaction to execute Write(Q) successfully.Which is true?

1)both with give same result in all cases

2)both with give same result in few cases

3)both with give different result in all cases

4)both with give different result insome cases
User Avatar

1 Answer

Best answer
1 votes
1 votes

In basic time stamp ordering:
W-time stamp (Q) denotes the largest time stamp of any transaction that has executed write-(Q) successfully.

W-time stamp(Q) as the most recent transaction to execute Write(Q) "successfully"

1) both with give same result in all cases

this is correct option, because successful write operation will always bre done by the younger transaction, and younger transaction always has the larger timestamp than older transactions.

• selected by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
gatecrack asked Sep 5, 2018
389 views
transaction and concurrency control protocol
Consider th following schedule r1(A)r2(B)r3(C)w1(B)w2(C)w3(D) Find the schedule which are possible to execute by strict 2PL protocol? consider commit operation as immediate last operation of each transaction
Consider th following scheduler1(A)r2(B)r3(C)w1(B)w2(C)w3(D)Find the schedule which are possible to execute by strict 2PL protocol? consider commit operation as immediate...
User Avatar
0 votes
0 votes
2 answers
2
joshipratik232 asked Aug 16, 2022
472 views
Transaction and concurrency control
Does Conservative 2PL ensures Recoverability ? If Yes then Does it ensures Cascadeless or Strict recoverable schedule ?
Does Conservative 2PL ensures Recoverability ? If Yes then Does it ensures Cascadeless or Strict recoverable schedule ?
User Avatar
1 votes
1 votes
1 answer
3
Verma Ashish asked Aug 25, 2018
2,078 views
Transaction & Concurrency control
Which of the following statement is/are incorrect? A: A schedule following strict two phase locking protocol is conflict serializable as well as recoverable. B: Checkpoint in schedules are inserted to ensure recoverability. (A) Only 1 (B) Only 2 (C) Both 1 and 2 (D) None
Which of the following statement is/are incorrect? A: A schedule following strict two phase locking protocol is conflict serializable as well as recoverable.B: Checkpoint...
User Avatar
Link Copied!