When the transaction finishes the final statement the transaction enters into

Related MCQs

• 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
•                means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
• 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                      requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.
• A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a
• 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.
• ____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
• Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.