What is the lock types supported in SQL Server ?
October 28, 2007 · Filed Under MS SQL Server Interview Questions, Placement Questions
 Don't want to miss a single bit? Subscribe By Email for Daily Jobs |
There could be thousands of concurrent users trying to read or modify the database, sometimes exactly the same data. If not for locking, your database would quickly lose its integrity.
The following basic types of locks are available with SQL Server:
- Shared locks: Enable users to read data but not to make modifications.
- Update locks: Prevent deadlocking (discussed later in this session).
- Exclusive locks: Allow no sharing; the resource under an exclusive lock is unavailable to any other transaction or process.
- Schema locks: Used when table-data definition is about to change—for example, when a column is added to or removed from the table.
- Bulk update locks: A special type of lock used during bulk-copy operations.
Related Articles
- How many groups of roles are supported in SQL Server ? Explain them
- What is T-SQL ?
- Explain Sliding Window
- Explain the Physical Structure of a Database
- What is OLAP ?
-
Subscribe
-
Job In Companies
-
Latest Jobs- TCS Freshers Walkin Banking Jobs - TCS BPO
- Sutherland Freshers Walkin
- Syntel Freshers Walkin
- Citigroup Freshers Walkin Jan 6 - 7
- NVIDIA Corp Recruits Freshers Senior Hardware Engineer
- BA Continuum Sol Recruits Freshers Tech Associate
- Convergys Recruits Freshers Technician - Network Services
- Bose Recruits Freshers TECHNICIAN
- RR Donnelley Recruits Freshers Customer Service Executive
- Zensar Tech Recruits Freshers Customer Service Executives