10 likes | 107 Views
Quiz 5. List ACID properties of transactions and briefly explain why the properties of A and D are useful in DBMS. What is conflict serializability? How is it related to view serializability?
E N D
Quiz 5 • List ACID properties of transactions and briefly explain why the properties of A and D are useful in DBMS. • What is conflict serializability? How is it related to view serializability? • Provide an example of a schedule (not serial) which is strict and serializable. It should contain at least 1 conflict. Show why it has the property. • What are the properties of the following schedule? w2(x) r3(x) C3 w1(y) C1 r2(y) w2(z) C2