Practice mode DBMS and SQL

Which pair of operations from two different transactions T1 and T2 does NOT conflict?

Correct answer B. R1(X) and R2(X)

Explanation

Two operations conflict when they belong to different transactions, access the same data item, and at least one of them is a write. Two reads of X do not change it, so their order makes no difference and they can be swapped freely. Read-write, write-read and write-write pairs on the same item conflict, because swapping them can change what a transaction reads or the final value.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.