Explain shared, exclusive, row-level, table-level, and intent locks.

Answer preview

Databases use locks to serialise conflicting access. They vary along two dimensions: mode (what the lock allows others to do — shared vs exclusive) and granularity (what it covers — row, page, table).…