Explanation:Resources section lists all the resources that were involved in the deadlock, which locks each process acquired and which locks they requested. 8. ___________ is a deadlock between a statement that is reading and a statement that is performing some form of data modification.
A. Reader
B. Writer
C. Reader-Writer
D. All of the mentioned
Answer:A
Explanation:Resources section lists all the resources that were involved in the deadlock, which locks each process acquired and which locks they requested. 8. ___________ is a deadlock between a statement that is reading and a statement that is performing some form of data modification.
A. Reader B. Writer C. Reader-Writer D. All of the mentioned
Explanation:When you look at the resources involved, you’ll see that the signature of this form of deadlock is locks that are all either a shared (S) lock granted and an exclusive (X) lock requested or an X lock granted and an S lock requested. 9. Which of the following query returns object names from partition IDs ?