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:

Related MCQs

• 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.
• If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
• If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
• If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called
• In the                        scheme, a transaction that wants to update the database first creates a complete copy of the database.
• 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 name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called
• Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
• Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
•          means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.