In the context of concurrency control, a given pair of operations in a schedule is called conflict schedule if
(A) At least one of the operations is write operation.
(B) Both the operations are performed on the same data item.
(C) Both the operations are performed by different transactions.
(D) Both the operations are performed on different data items.
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. (A), (B) and (C) only
Explanation
Two operations conflict if they are from different transactions, on the same data item, and at least one is a write.
More Database Management Systems questions
- Match List I with List II.
- On the basis of above given table structures, retrieve the distinct employee ID (EMPID) of all employees of university who are working on p…
- Given below are two statements to find the sum of salaries of all employees of the English department as well as the maximum, minimum and a…
- Which of the following query/queries return the employee ID and name of employees whose salary is greater than the salary of all employees…
- In reference to the above given table structures, which of the following query/queries will drop the 'SALARY' column from 'EMPLOYEE' table?…
- Refer table, structures given above. The university decided to give all employees in the 'SCIENCE' department a 20% rise in salary. Which o…