Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?

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.
• 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 case of any shut down during transaction before commit which of the following statement is done automatically?
• If a node is locked in                      explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
• If a node is locked in                          then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.
• If a node is locked in                              the subtree rooted by that node is locked explicitly in shared mode, and that explicit locking is being done at a lower level with exclusive-mode locks.
• If needed to split a node or coalesce it with its siblings, or redistribute key values between siblings, the crabbing protocol locks the parent of the node in                           mode.
• The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction finishes.
•          means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
• If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by