REI Systems Interview Question

What about Isolation level?

Interview Answer

Anonymous

Mar 1, 2010

Shared Lock – will be applied if any read operaction, multiple callers read the data during this lock but no one modify the data (no exclusive lock allowed) and this lock will be released all data returned to caller. Exclusive Lock – will be applied for modifying the data and no read operation are allowed (shared lock) until this lock released.