In crabbing protocol to inset or delete a key value the leaf

in-crabbing-protocol-to-inset-or-delete-a-key-value-the-leaf

In crabbing protocol to inset or delete a key value the leaf node has to be locked in ___________ mode.

A. Shared

B. Exclusive

C. Read only

D. None of the mentioned

I had been asked this question during an online interview.

This interesting question is from Concurrency in Index Structures topic in section Concurrency Control of Database Management

Correct answer is B. Exclusive

The best I can explain: Crabbing protocol moves in a crab like manner down the index tree.