Question: what is the difference between row level locking and table level locking?
Answer: Table-level locking systems always lock entire tables. Row-level locking systems can lock entire tables if the WHERE clause of a statement cannot use an index. ... Row-level locking systems can lock entire tables if a high number of single-row locks would be less efficient than a single table-level lock.