0
If you lock a row in a database you maintain data integrity. If two sources attempt to update the same record at the same time you could run into concurrency issues.
The database momentarily locks a record when you are updating it on its own.
To specifically lock a record, and subsequently unlock the record gives you more control. This is load bearing on the database and typically you do not want to do this.
One such case that this makes sense would be in the following situation:
If you need to update a row and that update is based on calculation that you will make; based upon information presently in that record and other associated records / tables, AND this calculation may take a few seconds (rather than instant); THEN you will want to lock the associated records, perform your calculations; update the data and then release the lock.
This insures that no changes will occur to the data, that your calculations are relying on, while you are performing your task.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Which type of lock allows for individual accountability?
smart lock
How long must banks retain used cheques?
Actually or Practically speaking, Forever. Banks do not destroy any of their used cheques or receipts or statements. They will be preserved forever in a safe location. There are numerous cases where confusions or court cases arise even after 10 or 15 years of a transaction and the bank is asked to provide more details. In such cases if the bank destroys its documents, the situation would become a dead-lock, one that cannot be resolved. So banks mostly retain all their artefacts.
How do you reset a 3 digit nu-set lockbox combo?
Opening Instructions: I. Slide the lever (located above the dials on the front of the lid) down to open the lid.II. Lift the lid from the security lock box to place or remove the keys inside the vault. Resetting Combination Instructions: 1. Your NuSet Security Lock Box is factory preset to 0-0-0. 2. Open lid using the "Opening Instructions" Step I & II from above. 3. Lift the lid from the security lock box. 4. Make certain the lever remains up in the closed position with the last combination set. 5. Insert the "Reset Key" (included) all the way into the side of the lid and make a 1/4 turn. 6. Once the key has been turned, roll the dials one at a time until the desired combination is aligned. Tip : Write down the new combination to prevent loss of the new combination. 7. After the new combination resetted, return the key to upward position and remove it from the lid. 8. Very Important! Check combination before placing the lid to the lock box body. Return the lever to closed/up position. If the lock retracts, the combination has been successfully changed. Please visit NusetLock.com or call toll-free 800-60-NUSET for details.
What credit check monitoring services are there?
The following companies offer credit monitoring services: Experian, Credit Check Instantly, Equifax, Free Scores, Identity Guard, Trusted ID, Life Lock, Credit Report, to name a few.
What are some different types of tax shelters?
Some different types of tax shelters include real estate, investment accounts and retirement accounts. These will allow people to save money by not paying tax and they will have to lock their money into the investment for a given time period.
What is the prefix of lock?
un- unlock
How do you say lock unlock in french?
Lock = Bloqué Unlock = Débloqué
How do you unlock lock code for nokia5233?
lock phone nokia 5233 unlock
How do you unlock the lock in wireless quest?
You search for the combination at the school , and you go to the lock and unlock .
What is pfefix of lock?
A prefix of lock is unlock.
How do you unlock the zipper lock code when i am forget number?
How do you unlock the zipper lock code when i am forget number
What is the prefix lock?
unlock
Is the dash door lock button on a 99 E320 supposed to lock as well as unlock?
Yes. I believe you can push down to unlock, and up to lock.
Why does my automatic doors only unlock but not lock?
they do lock, idiot
How do you unlock omakase lock?
omakase lock p905i foma
You want to use your Shift key to unlock the Caps Lock Since your computer came back from servicing you have to unlock Caps Lock by pressing Caps Lock a second time?
Yes, by pressing the Caps Lock key a second time it will unlock.
How do you unlock sim lock on a blackberry?
If you want to unlock your blackberry mobile phone from the sim lock,I would suggest you to get an unlock code from Unbblock.com at low price.
