search
Log In
0 votes
313 views
Which of the following is false?

a)All the schedules which are allowed under basic time stamp ordering protocols are also allowed under Thomas write rule.

b)Schedules which are allowed under Thomas write rule are also allowed under multi-version timestamp ordering protocol.

c)All the schedules which are not allowed Thomas write rule are also not allowed in a multi-version timestamp ordering protocol.

d)None.
in Databases
edited by
313 views

2 Answers

0 votes

The hierarchy is like this :

$I$ is $false,$ Some allowed under basic timestamp are not allowed under thomas write rule

$II$ is $false,$ Some allowed under thomas write rule are not allowed under multiversion timestamp ordering protocol

$III$ is $false,$ Some not allowed under thomas are allowed under multiversion

0
can you please mention the source from where you have referred the pic?
0
actually i created this on my own. I remember this from a solution of a question from testbook test, basic timestamp and thomas write relation can be easily seen, I don't know about multi-version, though I am sure testbook would not be wrong in this solution. If I find a source i will post it here.
1

https://gateoverflow.in/217350/understanding-multiversion-timestamp-ordering-protocol 

i have referred the above link in which it is mentioned that multiversion timestamp ordering is superset of thomas write rule. So according to this the option B is true and option C is false and from this link and korth https://www.geeksforgeeks.org/dbms-concurrency-control-protocol-thomas-write-rule/  they have mentioned that all the possible scheules under basic timestamp are also allowed in thomas write rule. So option A is true.

0
A is correct as schedule accepted by Thomas Write are superset of basic time stamp ordering.

B is correct.

I have no idea about option C.
0 votes
A is correct as schedule accepted by Thomas Write are superset of basic time stamp ordering.

B is correct.

I have no idea about option C.

Related questions

1 vote
0 answers
1
158 views
Which of the following time stamp ordering protocol(s) allow the following schedules? $T:W_1(A)\ W_2(A)\ W_3(A)\ R_2(A)\ R_4(A)$ Time stamps: $T_1=5,T_2=10,T_3=15,T_4=20$ Thomas write rule Multiversion time stamp protocol Basic Time stamp All of these
asked Jan 13, 2019 in Databases Gupta731 158 views
0 votes
0 answers
2
146 views
the table “Sales89” contains information about the address,zip,sale-date,price and inflamation-adjusted “real-price” of 222 sales of single family homes in calcutta during 1989.Here is the table schema
asked Dec 19, 2018 in Databases Shivam Kasat 146 views
0 votes
0 answers
3
0 votes
1 answer
4
...