« previous next »

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

ss2343

  • Hero Member
  • *****
  • Posts: 548
on: Jul 7, 2018
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
Reply #1 on: Jul 7, 2018
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
« previous next »
 

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

In 1885, the Lloyd Manufacturing Company of Albany, New York, promoted and sold "Cocaine Toothache Drops" at 15 cents per bottle! In 1914, the Harrison Narcotic Act brought the sale and distribution of this drug under federal control.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Process Flow Diagram of a Dual-Stage Pressure System Process Flow Diagram of a Dual-Stage Pressure System
Cultures Ideal Body Types Cultures Ideal Body Types
The General Process of Sensation The General Process of Sensation
The Process of Sperm Formation The Process of Sperm Formation
Termination of the process of translation Termination of the process of translation
Three-Phase Process of Hemostasis Three-Phase Process of Hemostasis
Video: Chronology of leptin research (A history of leptin research)

For a complete list of videos, visit our video library