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.

Related MCQs

• 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.
• Which of the following command makes the updates performed by the transaction permanent in the database?
• In the                      phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• The          lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
• The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
•          means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.