Explanation:When one data item is waiting for another data item in a transaction then system is in deadlock. 2. The deadlock state can be changed back to stable state by using _____________ statement.
A. Commit
B. Rollback
C. Savepoint
D. Deadlock
Answer:A
Explanation:When one data item is waiting for another data item in a transaction then system is in deadlock. 2. The deadlock state can be changed back to stable state by using _____________ statement.
A. Commit B. Rollback C. Savepoint D. Deadlock
Explanation:Rollback is used to rollback to the point before lock is obtained. 3. What are the ways of dealing with deadlock ?