Explain optimistic and pessimistic concurrency?

Question Posted / sudha

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

What is the difference between UNION and UNIONALL?

What is difference between TRUNCATE and DELETE statement

what is the difference between group and having give an example with query and sample output

Explain the commands in sql server?

Define left outer join in sql server joins?

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

What is autocommit mode in sql server?

can you instantiate a com object by using t-sql? : Sql server database administration

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

explain declarative management framework (dmf) in sql server 2008?

What is an etl file?

How many cores do I need for sql server 2016?

For more SQL Server Interview Questions Click Here