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

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.