...
Programming
October 11, 2023
Nielit Scientist-B IT 4-12-2016
October 11, 2023
Programming
October 11, 2023
Nielit Scientist-B IT 4-12-2016
October 11, 2023

Database-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
A
This schedule is serialized and can occur in a scheme using 2PL protocol
B
This schedule is serializable but cannot occur in a scheme using 2PL protocol
C
This schedule is not serialiable but can occur in a scheme using 2PL protocol
D
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).
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).
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!