What are the lock types?
Submitted by: AdministratorSQL server supports following locks
Shared lock
Update lock
Exclusive lock
Shared lock
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.
Update locks
This lock is used with the resources to be updated.
Exclusive locks
This kind of lock is used with data modification operations like update, insert or delete.
Submitted by: Administrator
Shared lock
Update lock
Exclusive lock
Shared lock
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.
Update locks
This lock is used with the resources to be updated.
Exclusive locks
This kind of lock is used with data modification operations like update, insert or delete.
Submitted by: Administrator
Read Online SQL Notification Services Job Interview Questions And Answers
Top SQL Notification Services Questions
☺ | Explain OPENQUERY function and OPENROWSET function? |
☺ | Define data, entity, domain and referential integrity? |
☺ | Define transaction and transaction isolation levels? |
☺ | How does Notification Services Work? |
☺ | What is Isolation Levels? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |