The deadlock in a set of a transaction can be determined by

Related MCQs

• The three basic techniques to control deadlocks are: deadlock ____, deadlock detection, and deadlock avoidance.
• 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 system has entered an undesirable state (for example, deadlock), as a result of which a transaction cannot continue with its normal execution. This is
• If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.
• The deadlock state can be changed back to stable state by using                             statement.
• The deadlock can be handled by
• The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction finishes.
•          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 an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
• When the transaction finishes the final statement the transaction enters into