what are different type of locks

what are different type of locks

what are different type of locks

View Answers

May 9, 2012 at 5:03 PM

Types of locks in JDBC:

Row and Key Locks:: It is useful when updating the rows (update, insert or delete operations), as they increase concurrency.

Page Locks: It locks the page when the transaction updates or inserts or deletes rows or keys. The database server locks the entire page that contains the row. The lock is made only once by database server, even more rows are updated. This lock is suggested in the situation where large number of rows is to be changed at once.

Table Locks: Utilizing table locks is efficient when a query accesses most of the tables of a table. These are of two types:

a) Shared lock: One shared lock is placed by the database server, which prevents other to perform any update operations.

b) Exclusive lock: One exclusive lock is placed by the database server, irrespective of the number of the rows that are updated.

Database Lock: In order to prevent the read or update access from other transactions when the database is open, the database lock is used.









Related Tutorials/Questions & Answers:
What is an object's lock and which object's have locks?
What is an object's lock and which object's have locks?   Hi, What is an object's lock and which object's have locks? Thanks
different type input in java
different type input in java  hiiiii... get input different different type like as DataInputStream,Scanner i want to get source code of these all type of input method. thank   Java Read through DataInputStream: import
Advertisements
What is mime type in HTML
What is mime type in HTML  what is mime type in html? is it different in new HTML5
What is mime type in HTML
What is mime type in HTML  what is mime type in html? is it different in new HTML5
What are the different types of AutoProxying?
What are the different types of AutoProxying?  Hi, What are the different types of AutoProxying? Thanks
What are different normalization forms?
What are different normalization forms?  What are different normalization forms?   Hi, 1NF: Eliminate Repeating Groups- Make a separate table for each set of related attributes, and give each table a primary key. Each
WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?
WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?  WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP
What are the different functions in sorting an array?
What are the different functions in sorting an array?  What are the different functions in sorting an array
What are different environments to configure hibernate?
What are different environments to configure hibernate?  Hi, What are different environments to configure hibernate? Thanks
What are the different modules in Spring framework?
What are the different modules in Spring framework?  Hi, What are the different modules in Spring framework? Thanks
What type of inheritance that php supports?
What type of inheritance that php supports?  What type of inheritance that php supports
with a different number, what’s the problem
with a different number, what?s the problem  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
with a different number, what’s the problem
with a different number, what?s the problem  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
What type of programming language is Java?
What type of programming language is Java?  Hi, What type of programming language is Java? Why anyone should learn Java? What is Java and what.... It helps to develop many different types of applications. This language is very
What is the return type of the main method?
What is the return type of the main method?  hi, What is the return type of the main method? thanks   Hi, In the java programming... to have a method named main in at least one class. The following is what must
what are different M.I.S reporting tools basically used?
what are different M.I.S reporting tools basically used?  what are different M.I.S reporting tools basically used
What are the different types of property and class mappings?
What are the different types of property and class mappings?  Hi, What are the different types of property and class mappings? thanks
what are different M.I.S reporting tools basically used?
what are different M.I.S reporting tools basically used?  write a java pgm using keyword super,static nd final
What is a join and explain different types of joins
What is a join and explain different types of joins  What is a join and explain different types of joins?   Hi, Joins are used in queries to explain how different tables are related. Joins also let you select data from
What are constructors ? explain different types of constructor with example
What are constructors ? explain different types of constructor with example  Hi, What are constructors ? explain different types of constructor... To know more related to What are constructors with examples
ModuleNotFoundError: No module named 'locks'
ModuleNotFoundError: No module named 'locks'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'locks' How to remove the ModuleNotFoundError: No module named 'locks'
what type of computer memory is used for temporary storage
what type of computer memory is used for temporary storage  what type of computer memory is used for temporary storage   RAM or Random Access Memory is a computer memory that is used for temporary storage of data. RAM
Conversion from string data type into different data types.
Conversion from string data type into different data types.  string str="World id Beutifull"; char chr[20]; char* chrctr ; Qustion is -How to store the 'str' value in 'chr' and 'chrctr'? int abc; sprintf(abc ,"%s",str
JDOM Attribute Example, How to convert value of attribute in different data type
JDOM Attribute Example, How to convert value of attribute in different data type In this tutorial, we will see how to retrieve the value of an attribute in different data type like int, float, boolean etc with the help of JDOM
ModuleNotFoundError: No module named 'kombu-locks'
ModuleNotFoundError: No module named 'kombu-locks'  Hi, My Python... 'kombu-locks' How to remove the ModuleNotFoundError: No module named 'kombu-locks' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'django-locks'
ModuleNotFoundError: No module named 'django-locks'  Hi, My Python... 'django-locks' How to remove the ModuleNotFoundError: No module named 'django-locks' error? Thanks   Hi, In your python
What type of headers have to be added in the mail function to attach a file?
What type of headers have to be added in the mail function to attach a file?  What type of headers have to be added in the mail function to attach a file
keeps coming up with a different number, what’s the problem.
keeps coming up with a different number, what?s the problem.  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
keeps coming up with a different number, what’s the problem
keeps coming up with a different number, what?s the problem  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
What are the different types of interfaces in java? - Java Interview Questions
What are the different types of interfaces in java?  Hi, Is it correct question.I faced this in one interview. If yes can u tell me please. thanks chandu
What is the return type of execute mehtod in jdbc - Java Beginners
What is the return type of execute mehtod in jdbc  Hi Deepak, u posted this answer. " Whatever it may be the statement type, like.... " String s="raja" , Here return type of s is string
ModuleNotFoundError: No module named 'pg-explain-locks'
ModuleNotFoundError: No module named 'pg-explain-locks'  Hi, My... named 'pg-explain-locks' How to remove the ModuleNotFoundError: No module named 'pg-explain-locks' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'pg-explain-locks'
ModuleNotFoundError: No module named 'pg-explain-locks'  Hi, My... named 'pg-explain-locks' How to remove the ModuleNotFoundError: No module named 'pg-explain-locks' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'django-db-locks'
ModuleNotFoundError: No module named 'django-db-locks'  Hi, My... named 'django-db-locks' How to remove the ModuleNotFoundError: No module named 'django-db-locks' error? Thanks   Hi, In your python
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what’s the problem?
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem?  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what’s the problem?
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem?  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s
JAVA what is different between static block and public static void main(String a[]) method
JAVA what is different between static block and public static void main(String a[]) method  what is different between static block and public static void main(String a[]) method,we execute method without main method(by static
type casting
type casting  what is type casting
What is the Best Jewelry for a Specific Type of Outfit?
What is the Best Jewelry for a Specific Type of Outfit? The best jewelry... to let the fashion trends tell you what to wear. For example, a movie premiere... occasion. For work you will choose a more relaxed type of the best jewelry
JavaScript type of Operator
JavaScript type of Operator       The JavaScript type of operator returns the datatype of an operand. You can see in the given example that we have used different variables
type casting
type casting  int n=20; n=sizeof((char)(float)n); what is n value
Different JRE
Different JRE  Java is platform independent. The why different JRE's there for differen operating systems
Type casting
Type casting  how to type cast a string value to byte array
fastest type of JDBC driver
fastest type of JDBC driver  What is the fastest type of JDBC driver
Document Type Definition
Document Type Definition  What is Document Type Definition
type casting
type casting  <--bean class-->method calllist is of object type... List (object type) <Object> totalList(int pi){ (adsbygoogle = window.adsbygoogle || []).push({}); try{ Query q= em.createQuery
type mismatch
type mismatch  Statement s= con.createStatement(); this line gives error of "type mismatch" I am using eclips nd new to servlet nd JDBC, Please help me, Thank you
Different tables present in MySQL
Different tables present in MySQL  What are the different tables present in MySQL? Which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2),ename varchar(10))?  
What is Linux?
What is Linux?        ...; Linux is a free Unix-type operating system originally developed by Linus... of GNU worked together to develop what we now take for granted, a derivative
data type
data type  which data type is used to store video file in mysql databse

Ads