What is a Lock and let me know Different types of locks?
Answers were Sorted based on User's Feedback
Answer / sreejith s t
Different Types of Locks are
1. Shared Lock
2. Exclusive Lock
3. Update Lock
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
What is policy management?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is INTVAL( )and where we use Plz any body help me
How can you set the threshold at which sql server will generate keysets asynchronously?
What is use of except clause? How it differs from not in clause?
What is table join?
How much is a sql server license?
How to make a remote connection in a database?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Which system tables contain information on privileges granted and privileges obtained
How do I start and stop sql server?
What is tempdb in sql server?