What is a Lock and let me know Different types of locks?
Answer Posted / udhaya
Shared (S) Used for operations that do not change or update
data (read-only operations), such as a SELECT statement.
Update (U) Used on resources that can be updated. Prevents
a common form of deadlock that occurs when multiple
sessions are reading, locking, and potentially updating
resources later.
Exclusive (X) Used for data-modification operations, such
as INSERT, UPDATE, or DELETE. Ensures that multiple updates
cannot be made to the same resource at the same time.
Intent Used to establish a lock hierarchy. The types of
intent locks are: intent shared (IS), intent exclusive
(IX), and shared with intent exclusive (SIX).
Schema Used when an operation dependent on the schema of a
table is executing. The types of schema locks are: schema
modification (Sch-M) and schema stability (Sch-S).
Bulk Update (BU) Used when bulk-copying data into a table
and the TABLOCK hint is specified
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are different types of statements that are supported by sql?
How to insert data with null values?
what are the important architecture components of SSRS?
Name three of the features managed by the surface area configuration tool? : sql server security
How can i Relate Tables in SSIS
Explain something about security and SQL Azure?
Explain view in sql server?
1 01 101 01010
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What happens if date-only values are provided as date and time literals?
What is indexing in sql server with example?
Does view occupy space?
How to create a store procedure with encryption?
What is ems sql management studio? : sql server management studio
How to use old values to define new values in update statements in ms sql server?