Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / vamsimadineni

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 do you mean by a Composite primary key?

0 Answers   Genpact,

Explain error handling in ssis?

0 Answers  

What is a dbms wizard?

0 Answers  

How to trouble shoot if unable to connect SQL Server

0 Answers  

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

Is resultset an interface?

0 Answers  

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

Explain ranking functions?

0 Answers  

What is store procedure? How do they work?

0 Answers  

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 Answers  

what are the advanced features in sql 2008?

2 Answers   Wipro,

For more SQL Server Interview Questions Click Here
Categories