FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Optimistic locking is a technique for SQL database applications that does not hold row locks between selecting and updating or deleting a row. The application is written to optimistically assume that unlocked rows are unlikely to change before the update or delete operation.

Detailed explanation-2: -There are two models for locking data in a database: Optimistic locking, where a record is locked only when changes are committed to the database. Pessimistic locking, where a record is locked while it is edited.

Detailed explanation-3: -Optimistic concurrency control (OCC), also known as optimistic locking, is a concurrency control method applied to transactional systems such as relational database management systems and software transactional memory. OCC assumes that multiple transactions can frequently complete without interfering with each other.

Detailed explanation-4: -The pessimistic approach allows the decision-makers to prepare for the worst possible outcomes. In the optimistic approach, the decision-makers believe that the chosen alternatives will bring about the best outcomes.