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.

Ads









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
What is mime type in HTML
What is mime type in HTML  what is mime type in html? is it different in new HTML5
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
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
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 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
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 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 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?  write a java pgm using keyword super,static nd final
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
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
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
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
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'
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
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
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
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
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
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.... For work you will choose a more relaxed type of the best jewelry because you don't
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
Different JRE
Different JRE  Java is platform independent. The why different JRE's there for differen operating systems
Different between getRequestParameterMap() and getRequestParameterValuesMap()
Different between getRequestParameterMap() and getRequestParameterValuesMap()  What is the different between getRequestParameterMap() and getRequestParameterValuesMap

Ads