Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
An existing database includes a table whose ID column has a clustered index definition. You are in
the process of creating a script to generate a stored procedure that should allow for the number of
locks and deadlocks to be reduced.
Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
An existing database includes a table whose ID column has a clustered index definition. You are in
the process of creating a script to generate a stored procedure that should allow for the number of
locks and deadlocks to be reduced.
Which of the following actions should you take?

A.
You should consider making use of the READ COMMITTED isolation level, and also include
XLOCK.

B.
You should consider making use of the READ COMMITTED isolation level, and also include
TABLOCKX.

C.
You should consider making use of the READ COMMITTED isolation level, and also include
ROWLOCK.

D.
You should consider making use of the READ COMMITTED isolation level, and also include
UPDLOCK.

Explanation:



Leave a Reply 3

Your email address will not be published. Required fields are marked *