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.

Related MCQs

• In the                        scheme, a transaction that wants to update the database first creates a complete copy of the database.
• A DBMS uses a transaction ____ to keep track of all transactions that update the database
• Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the                field of the page.
• A                      is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
• The problem of ordering the update in multiple updates is avoided using
• A                    consists of a sequence of query and/or update statements.
• Lost update problem is
• The log is a sequence of                     recording all the update activities in the database.
• The UPDATE SQL clause can _____________
• The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction finishes.