Home › GATE CSE › computerscience › Database Management Systems › Two operations from different transactions confl…
Two operations from different transactions conflict if
Athey belong to the same transaction
Bthey access different data items
Cthey are both reads of the same data item
Dsame data item, at least one is a write
Answer & Solution
Correct answer: D. same data item, at least one is a write
The standard definition of conflict: same item AND at least one write. Two reads on the same item don't conflict because their order doesn't change the outcome. Same-transaction operations are not considered conflicts in this framework. Different items means no shared state to fight over.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment