Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Lock and let me know Different types of locks?
- 2 Answers
- 5096 Views
- I also Faced
- E-Mail Answers
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
Explain security with sql azure?
How to provide login information for a new odbc dsn?
Explain user defined functions?
What is onf in normalization form?
What is surrogate key? : sql server analysis services, ssas
Explain about the command-line tool SQLCMD?
What are the basic functions for master, msdb, model, tempdb databases?
Where can you find the error log information? : sql server database administration
What is sub-query in sql server? Explain its properties.
What are synonyms?
What are indexes in sql?
How to use user defined functions in expressions?
How to download and install microsoft .net framework version 2.0?
Explain about system stored procedure?
You want to implement the many-to-many relationship while designing tables. How would you do it?
