a) Atomicity b) Performance c) Consistency d) Reliability e) Serializability Wha
ID: 2247456 • Letter: A
Question
a) Atomicity b) Performance c) Consistency d) Reliability e) Serializability What kind of anomaly did we not discuss our exploration of interleaved transactions? a) Inconsistent read b) Repeatable read c) Partially-lost update d) We discussed all of the above e) We discussed none of the above Which of the following access pattern is NOT at risk for an interleaved transaction anomaly/conflict? a) WR b) WW c) RW d) RR Why is the pattern you chose above NOT at risk for an anomaly/conflict? Here is one of the transaction schedules we discussed in class: Draw the serial schedule (there is only one) that results in identical database state, that is where the bank has same amount of money, and A and B each have the amounts they have at the end of the schedule above.Explanation / Answer
38 Repeatable read
39 RR is not a risk
because the data is not changed and consistancy is maintained
40
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.