How do we generally recover from a deadlock? (TCS)Options: Pick one correct answer from belowBy aborting all the transactionsBy rolling back all the transactionsBy rolling back only a selected number of transactionsNone of the mentioned

What is Deadlock? List the conditions that lead to deadlock.

The Methods for dealing with the deadlock problem isa.Use a protocol to make sure that the system never enters in to the deadlock stateb.Ignore the problem, and pretend that deadlock never occur in the system, the unix operating system uses this solutionc.All of thesed.Allow the system to enter a deadlock state and then recover

One can only prevent deadlock by adopting a policy that must eliminate all of the deadlock conditions. Group of answer choicesTrueFalse

Which mechanism is commonly used to break deadlocks in a database system?Rollback and RestartTimeout mechanism

What do you call a transaction that is responsible for a deadlock and has been chosen to be rolled back?Question 17Select one:a.A witnessb.A hostagec.A criminald.A victime.A felon