MS SQL Server Optimization Question:
Download Job Interview Questions and Answers PDF
What is Shared lock?
Answer:
Shared 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.
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.
Download SQL Server Optimization Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What are the steps you will take, if you are tasked with securing an SQL Server? | What is Update locks? |