Explain the process of using optimistic locking. What will be ...

[ss2343]

Explain the process of using optimistic locking.
 
  What will be an ideal response?

Question 2

Each of the following is a way of inserting data into a Microsoft Access table except ________.
 
  A) Datasheet view
  B) a data entry form
  C) QBE
  D) SQL

[juiceman1987]

Answer to Question 1

Optimistic locking makes the assumption that no conflicts will occur. Data is read, the transaction is processed, updates are issued, and then a check is made to see if a conflict occurred. If a conflict does occur, the transaction is repeated until it completes without a conflict. Thus, the lock is not secured until the transaction is completed. This reduces the amount of time that the lock is held.

Answer to Question 2

D