If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
(a) Intention lock modes
(b) Intention-shared-exclusive mode
(c) Intention-exclusive (IX) mode
(d) Intention-shared (IS) mode
I had been asked this question at a job interview.
Enquiry is from Multiple Granularity topic in section Concurrency Control of Database Management
Select the correct answer from above options
Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience