Database Interview in Technical Lead Round: What
More DBA job interview questions and answers at
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.
Other Job Interview Questions