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 |
New concepts of sql server 2005 use in your project.
wat new abt truncate in sql server
what is trigger
1 Answers CarrizalSoft Technologies, NIIT,
What are functions in the sql server?
How to configure and test odbc dsn settings?
How to generate random numbers with the rand() function in ms sql server?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is measure group, measure? : sql server analysis services, ssas
What do you mean by data manipulation language?
How to rename databases in ms sql server?
Explain what role entity and relationship play in an ER diagram.
How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)