What is a Lock and let me know Different types of locks?

Answer Posted / sreejith s t

Different Types of Locks are
1. Shared Lock
2. Exclusive Lock
3. Update Lock

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between commit and rollback?

515


What is the difference between a fill factor of 100 and 0?

538


How to add an address record into adventureworkslt?

582


What is for xml in sql server?

550


How to make conditional sum in ssrs?

132






What happens if null values are involved in boolean operations?

568


How sql server executes a statement with nested subqueries?

515


what is isolation level at dead lock?

1759


Explain in brief how sql server enhances scalability of the database system?

487


What are the differences between triggers and stored procedures?

547


What is row-level compre?

551


What is the difference between update lock and exclusive lock?

504


Do you know what is user defined datatypes and when you should go for them?

508


Explain the categories of stored procedure?

537


How to list all login names on the ms sql server?

542