Can you explain different types of locks in sql server?

Question Posted / mohd shariq

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

More SQL Server Interview Questions

Is it possible in sql table to have more than one foreign key?

How to find the list of fixed hard drive and free space on server?

sql database suspect We have a sql database that is showing as suspect. How can we recover?

How can we write or define DDL statements in Sql server and DML statements?

What is Index Segmentation ?

Is there any difference between primary key and unique with the not null condition?

What are the dis_advantages of stored procedures, triggers, indexes?

Explain trigger classes i.e. Instead of and after trigger?

What is user-defined functions? What are the types of user-defined functions that can be created?

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

What is the difference between substr and charindex in the sql server?

For more SQL Server Interview Questions Click Here