Question

If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ­­­­­­__________ on all the records belonging to that file.

(a) Explicit lock in exclusive mode

(b) Implicit lock in shared mode

(c) Explicit lock in shared mode

(d) Implicit lock in exclusive mode

I have been asked this question by my college professor while I was bunking the class.

I need to ask this question from Lock-Based Protocols topic in section Concurrency Control of Database Management

Answer 1

Right answer is (d) Implicit lock in exclusive mode

Best explanation: If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an implicit lock in exclusive mode on all the records belonging to that file.