Peter is writing a program that has a GUI front-end and uses a MS SQL database as a backend.
Peter’s application will repeatedly update and call upon specific tables in the database on a
regular basis. Peter wants to make sure that his program always has the ability to update the
database and that no other calls or updates can touch the database tables used at the same time.
How could Peter accomplish this in his application?
A.
Explicit lock
B.
SET TRANSACTION EXCLUSIVE
C.
SET TRANSACTION WRITE
D.
Implicit lock
Explanation: