You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?
A. Bind your application with ISOLATION(UR)
B. Bind your application with ISOLATION(CS)
C. Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME)
D. Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)
Answer:D
You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?
A. Bind your application with ISOLATION(UR) B. Bind your application with ISOLATION(CS) C. Bind your application with CONCURRENTACCESSRESOLUTION (WAITFOROUTCOME) D. Bind your application with CONCURRENTACCESSRESOLUTION (USECURRENTLYCOMMITTED)