Interview Questions

Database Interview in Technical Lead Round: What is lock granularity?

Technical Lead Round Interview Questions and Answers


(Continued from previous question...)

Database Interview in Technical Lead Round: What is lock granularity?

There are many locks available for the database system to have like Intent Shared, Shared, Intent exclusive, exclusive and Shared Intent exclusive. Locking granularity refers to the size and hence the number of locks used to ensure the consistency of a database during multiple concurrent updates.

(Continued on next question...)

Other Interview Questions