What is a Lock and let me know Different types of locks?

Answers were Sorted based on User's Feedback



What is a Lock and let me know Different types of locks?..

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

What is a Lock and let me know Different types of locks?..

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

Post New Answer

More SQL Server Interview Questions

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  


What is lookup override?

0 Answers   Informatica,


where can you add custom error messages to sql server? : Sql server administration

0 Answers  


What do you mean by a dependent functionality in a build?

0 Answers   HCL,


What are the advantages of partitioning?

0 Answers  






List the ways in which dynamic sql can be executed?

0 Answers  


what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  


How make remote connection in database?

1 Answers  


What is Self Join?

4 Answers  


What does it mean if @@cursor_row returns a negative number?

0 Answers  


What are basics of policy management?

0 Answers  


How to make remote connection in database?

0 Answers  


Categories