With optimistic locking,locks are first issued,then the transaction is processed,and then the locks are released.

Question

Quizplus · Accepted Answer

With optimistic locking, locks are not issued initially. Instead, the transaction reads the data and checks if it has been modified by any other transaction. If the data has not been modified, the transaction proceeds and updates the data, and then releases the locks. If the data has been modified, the transaction aborts and retries later. Therefore, there are no locks issued before the transaction is processed.

With Optimistic Locking,locks Are First Issued,then the Transaction Is Processed,and