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...

what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?

Answer Posted / ajay.lavanuru

The lock mode convey the message of lock status starting
from low level hierarchy to high level hierarchy.

exclusive lock ---high priority
if this lock is enabled then 1 cant do nothing on the table.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create your own reports in sql developer?

976


What is the command used to fetch first 5 characters of the string?

1336


What are its different types of dbms?

957


Can a composite key be null?

912


What are the constraints available in sql?

999


what is myisam? : Sql dba

1001


Show how functions and procedures are called in a pl/sql block.

1042


What are the set operators in sql?

1032


What are the basic sql commands?

1039


What is keys and its types?

1022


Define tables and fields in a database

1081


How will you distinguish a global variable with a local variable in pl/sql?

1093


What do you mean by stored procedures?

953


what is sql? : Sql dba

973


What is the life of an sql statement?

964