Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
Question 272
|
In the context of concurrency control, a given pair of operations in a schedule is called conflict schedule if
(A) At level one of the operations is write operations
(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
Choose the correct answer from the options given below:
(A) At level one of the operations is write operations
(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
Choose the correct answer from the options given below:
(A) and (B) only
|
|
(A), (B) and (C) only
|
|
(A), (C) and (D) only
|
|
(C) and (D) only
|
Question 272 Explanation:
If you observe the problems given below then the reason behind their occurrence is having at least one write operation on the same data item by different transactions.
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_40.png)
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_41.png)
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_42.png)
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_40.png)
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_41.png)
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_42.png)
Correct Answer: B
Question 272 Explanation:
If you observe the problems given below then the reason behind their occurrence is having at least one write operation on the same data item by different transactions.
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_40.png)
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_41.png)
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_42.png)
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_40.png)
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_41.png)
![](https://solutionsadda.in/wp-content/uploads/2020/11/Screenshot_42.png)
Subscribe
Login
0 Comments