You are designing the data access layer (DAL) for an application that uses Microsoft SQL Server 2008, Microsoft ADO.NET, and Microsoft Visual Studio 2010. Conflicts are occurring in the SQL Server database due to concurrent updates. You need to design a database locking strategy that meets the following requirements:

Resolves concurrent update conflicts without loss of data

Ensures that data conflicts can be resolved by users

Locks only the data necessary for updates

What should you do?

Question

You are designing the data access layer (DAL) for an application that uses Microsoft SQL Server 2008, Microsoft ADO.NET, and Microsoft Visual Studio 2010. Conflicts are occurring in the SQL Server database due to concurrent updates. You need to design a database locking strategy that meets the following requirements:

Resolves concurrent update conflicts without loss of data
Ensures that data conflicts can be resolved by users
Locks only the data necessary for updates

What should you do?

Accepted Answer

D. Use optimistic locking.

Answer

A. Use optimistic locking.

Answer

B. Use pessimistic locking.

Answer

C. Use pessimistic locking.

You are designing the data access layer (DAL) for an application that uses Microsoft SQL Server 2008, Microsoft ADO.NET, and Microsoft Visual Studio 2010. Conflicts are occurring in the SQL Server…

Question

Options

How the community answered

Community Discussion