UGC NET CSE | October 2020 | Part 2 | Question: 48

Question

In the context of concurrency control, a given pair of operations in a schedule is called conflict schedule if

1. At least one of the operations is write operation
2. Both the operations are performed on the same data item
3. Both the operations are performed by different transactions
4. Both the operations are performed on different data items

Choose the correct answer from the options given below:

• A. $(a)$ and $(b)$ only
• B. $(a)$, $(b)$ and $(c)$ only
• C. $(a)$, $(c)$ and $(d)$ only
• D. $(c)$ and $(d)$ only

Answer 1

Conflicting operations: Two operations are said to be conflicting if all conditions satisfy: 

• They belong to different transactions
• They operate on the same data item
• At Least one of them is a write operation

Only (a),(b),(c) statements are correct. Option (B) is correct answer.