ISC Exam Questions

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

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?

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.