Internet News Internet Investing Internet Technology Windows Internet Tech.
Locks are the mechanism that prevent more than one user at a time making changes to the database.
There are several types of locks that define their scope. Row share, Row exclusive, share, share row exclusive and exclusive are the several modes of a table lock. It allows the user to change one or two rows of data in a table. Any row in a table that is not held by a row-level lock can be changed by another user. All rights reserved.