What is Shared lock?
Submitted by: AdministratorShared Lock allows simultaneous access of record by multiple Select statements.
Shared Lock blocks record from updating and will remain in queue waiting while record is accessed for reading.
If update process is going on then read command will have to wait until updating process finishes.
Submitted by: Administrator
Shared Lock blocks record from updating and will remain in queue waiting while record is accessed for reading.
If update process is going on then read command will have to wait until updating process finishes.
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. |
