1.

What Do You Mean By Optimistic Locking?

Answer»

Database tables are open for read/write over entire network for all users/sessions. It results in INCREASED throughput but results in the loss of UPDATES during parallel ACCESS.

For example:-

  1. User X reads a record
  2. User y reads the same record
  3. User x updates that record
  4. User y updates the same record

User y has now over-written the CHANGES that User x made.

Database tables are open for read/write over entire network for all users/sessions. It results in increased throughput but results in the loss of updates during parallel access.

For example:-

User y has now over-written the changes that User x made.


Discussion

No Comment Found

Related InterviewSolutions