In general,optimistic locking is the preferred technique for Internet databases.

Question

Quizplus · Accepted Answer

Optimistic locking is typically used in Internet databases because it enables multiple users to access and update the same data simultaneously without conflicts. In optimistic locking, each user assumes that the data they are accessing will not be modified by anyone else during their session. The system checks for conflicts only when a user attempts to commit changes, at which point the system compares the current version of the data with the version the user accessed. If the data has been modified by someone else in the meantime, the system will return an error message and ask the user to refresh their view before trying again. This approach is generally preferred over pessimistic locking, which requires exclusive locks on data and can lead to contention and performance issues.

In General,optimistic Locking Is the Preferred Technique for Internet Databases