Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
(a) Higher-level lock
(b) Lower-level lock
(c) Read only lock
(d) Read write
I have been asked this question by my school principal while I was bunking the class.
Question is from Lock Release and Undo Operations in division Recovery System of Database Management