Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

Related MCQs

• A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a
• The situation where the lock waits only for a specified amount of time for another lock to be released is
• A(n) ____ lock exists when concurrent transactions are granted Read access on the basis of a common lock.
• In a ____ lock, the DBMS will lock an entire disk page.
• When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj). Otherwise, Ti is rolled back (dies). This is
• When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti). This is
• Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
• 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