The system has entered an undesirable state (for example, deadlock), as a result of which a transaction cannot continue with its normal execution. This is

Related MCQs

• The three basic techniques to control deadlocks are: deadlock ____, deadlock detection, and deadlock avoidance.
• The transaction can no longer continue with its normal execution because of some internal condition, such as bad input, data not found, overflow, or resource limit exceeded. This is
•          means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
•                means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
• ____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
• If the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called:
• A system is in a              state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
• The deadlock in a set of a transaction can be determined by
• The deadlock state can be changed back to stable state by using                             statement.
• A transaction completes its execution is said to be