Explain optimistic and pessimistic concurrency?


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

Post New Answer

More SQL Server Interview Questions

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

0 Answers  


How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 Answers  


What is shrink log file?

0 Answers  


Which sql server table is used to hold the stored procedure script?

0 Answers  


Explain what is analysis service repository?

0 Answers  






Do you know what are the reporting services components?

0 Answers  


What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,


How to execute a sql statement using mssql_query()?

0 Answers  


Explain differentiate between a having clause and a where clause?

0 Answers  


hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 Answers  


How to defragment table indexes?

0 Answers  


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  


Categories