What are the lock types?
Submitted by: AdministratorMain lock types:
Shared: Applied to read only operations where the data is not modified. E.g.: Select statements.
Update: Applied to resources which can be updated. It resolves dead locks in case of multiple sessions are reading, locking or updating resources later.
Exclusive: Used for operations involving data modification. E.g.: Insert, Update, and Delete. This ensures that multiple updates are not made to the same data at the same time.
Intent: Establishes a lock hierarchy. E.g.: Intent shared Intent exclusive and Shared with intentexclusive.
Schema: Used when schema dependent operations are being executed. E.g.: Schema modification and Schema stability.
Bulk update: Used while bulk copying of data and Tablock is specified.
Submitted by: Administrator
Shared: Applied to read only operations where the data is not modified. E.g.: Select statements.
Update: Applied to resources which can be updated. It resolves dead locks in case of multiple sessions are reading, locking or updating resources later.
Exclusive: Used for operations involving data modification. E.g.: Insert, Update, and Delete. This ensures that multiple updates are not made to the same data at the same time.
Intent: Establishes a lock hierarchy. E.g.: Intent shared Intent exclusive and Shared with intentexclusive.
Schema: Used when schema dependent operations are being executed. E.g.: Schema modification and Schema stability.
Bulk update: Used while bulk copying of data and Tablock is specified.
Submitted by: Administrator
Read Online MS SQL Server Optimization Job Interview Questions And Answers
Top MS SQL Server Optimization Questions
☺ | What is Shared lock? |
☺ | What is Exclusive locks? |
☺ | What is Update locks? |
☺ | What are the steps you will take, if you are tasked with securing an SQL Server? |
☺ | What are the lock types? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |