Author Question: Explain the process of using optimistic locking. What will be an ideal ... (Read 82 times)

ss2343

  • Hero Member
  • *****
  • Posts: 548
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

  • Sr. Member
  • ****
  • Posts: 316
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



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Did you know?

The familiar sounds of your heart are made by the heart's valves as they open and close.

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

For a complete list of videos, visit our video library