Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.

Related MCQs

• A(n) ____ lock exists when concurrent transactions are granted Read access on the basis of a common lock.
• Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
• Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called
• An operation is said to be                      if executing it several times in a row gives the same result as executing it once.
• 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.
• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• The          lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.