Programming
October 11, 2023Nielit Scientist-B IT 4-12-2016
October 11, 2023Database-Management-System
Question 28
|
For the schedule given below, which of the following is Correct?
1 Read A
2 Read B
3 Write A
4 Read A
5 Write A
6 Write B
7 Read B
8 Write B
1 Read A
2 Read B
3 Write A
4 Read A
5 Write A
6 Write B
7 Read B
8 Write B
This schedule is serialized and can occur in a scheme using 2PL protocol
|
|
This schedule is serializable but cannot occur in a scheme using 2PL protocol
|
|
This schedule is not serialiable but can occur in a scheme using 2PL protocol
|
|
This schedule is not seralisable and cannot occur in a scheme using 2PL protocol.
|
Question 28 Explanation:
Let’s draw precedence graph,
Since cycle exist so not conflict serializable.
And we know that if the schedule is not serializable then it is not 2PL.
Hence correct option is (D).
![](https://solutionsadda.in/wp-content/uploads/2020/02/g1-1.jpg)
Since cycle exist so not conflict serializable.
And we know that if the schedule is not serializable then it is not 2PL.
Hence correct option is (D).
Correct Answer: D
Question 28 Explanation:
Let’s draw precedence graph,
Since cycle exist so not conflict serializable.
And we know that if the schedule is not serializable then it is not 2PL.
Hence correct option is (D).
![](https://solutionsadda.in/wp-content/uploads/2020/02/g1-1.jpg)
Since cycle exist so not conflict serializable.
And we know that if the schedule is not serializable then it is not 2PL.
Hence correct option is (D).
Subscribe
Login
0 Comments