250 views
0 votes
0 votes
Can conservative 2pl protocol can have Cascading Rollback Situation?

I guess no because here we lock all the data items so when I'll perform a write operation then no other transaction could run in parallel so no dirty read. Am I right?

1 Answer

0 votes
0 votes
yes absolutely in conservative 2PL we in beginning reserve resources or data items needed in transaction using locks..so problems like cascading rollback wont occur

Related questions

0 votes
0 votes
1 answer
1
Deepak Joshi asked Oct 8, 2023
564 views
A database relation R has 10 attributes (A, B, C, D,..., J)."CDEF" is known to be a candidate key of relation R. There may be other candidate keys, which are unknown. Wha...
1 votes
1 votes
0 answers
2
JAINchiNMay asked Dec 1, 2022
402 views
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false
0 votes
0 votes
1 answer
4
abhinowKatore asked Sep 8, 2022
257 views
If a schedule is not conflict-serializable. Is it serializable?