PrepAway - Latest Free Exam Questions & Answers

What needs to be put into place to ensure that two users cannot access and modify the same data within a datab

What needs to be put into place to ensure that two users cannot access and modify the same data within a databaase at the same time?

PrepAway - Latest Free Exam Questions & Answers

A.
OLE-DB locks

B.
Referential locks

C.
Software locks

D.
Semantic locks

Explanation:
If controls are not in place, two users can access and modify the samedata at the same time, which can be detrimental to a dynamic environment. To ensure that concurrency issues do not cause problems, processes can lock tables within a database, make changes, and then release the software lock. The next process that accesses the table will then have the updated information.


Leave a Reply