Question

Which of the following statements is true in
the context of recovery from dead lock?
A. All of the mentioned statements are true
B. In total rollback , additional information about the
state of all the running transactions is maintained
C. To break the deadlock, the most common solution
is to rollback one or more transaction
D. in partial rollback; transaction is aborted and restarted​

Answer 1

Answer:

c is correct answer...........

..

Answer 2

Answer: C. To break the deadlock, the most common solution

Explanation:  C. To break the deadlock, the most common solution is the correct statement.

There are two methods for getting out of a deadlock:

process's conclusion We can just destroy one or more processes to end the impasse.

Resource Preemption: We preempt some resources from processes and give those resources to other processes in order to break deadlocks via resource preemption.

Result for an image The most typical method of ending the stalemate is to rollback one or more transactions.

When the first process locks the first resource and the second process locks the second resource at the same moment, a deadlock results. The first process can be stopped and restarted to break the impasse.

#SPJ3