« previous next »

Author Question: Explain the process of using optimistic locking. What will be an ideal ... (Read 73 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?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Medications that are definitely not safe to take when breastfeeding include radioactive drugs, antimetabolites, some cancer (chemotherapy) agents, bromocriptine, ergotamine, methotrexate, and cyclosporine.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
The process of mitosis in an animal cell. The process of mitosis in an animal cell.
A hypothetical scenario illustrating the process of chemical selection A hypothetical scenario illustrating the process of chemical selection
An overview of the process of primary and secondary growth in a woody stem. An overview of the process of primary and secondary growth in a woody stem.
The healing process of a bone. The healing process of a bone.
After all valves have been properly measured and adjusted as necessary, start the reassembly process ... After all valves have been properly measured and adjusted as necessary, start the reassembly process ...
Diffusion as an entropy-driven process Diffusion as an entropy-driven process
Video: Structure of a Ribosome

For a complete list of videos, visit our video library