In the                        scheme, a transaction that wants to update the database first creates a complete copy of the database.

Related MCQs

• 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.
• 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:
• 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.
• A DBMS uses a transaction ____ to keep track of all transactions that update the database
• 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
• In                                  of Oracle, the database administrator creates a user account in the database for each user who needs access.
• The log is a sequence of                     recording all the update activities in the database.