Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

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.
• 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.
• If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
• 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 the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called:
• In the                        scheme, a transaction that wants to update the database first creates a complete copy of the database.
•                        refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
• When a program is abnormally terminated, the equivalent of a ____ command occurs.
• Which of the following command makes the updates performed by the transaction permanent in the database?