Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Lock and let me know Different types of locks?
- 2 Answers
- 4952 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
What do you mean by subquery?
How to choose all records from the table?
Can we update data in a view?
What is cursors?
How to get a list of columns in a view using the "sp_help" stored procedure?
What will be query used to get the list of triggers in a database?
Explain boyce and codd normal form(bcnf)?
What is in place upgrade in sql server?
What are the differences between stored procedure and view in sql server?
where the connection string store in the database
Explain query editor regions
How to test values returned by a subquery with the in operator?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What stored by the tempdb ? : sql server database administration
What are sql servers used for?
