Database Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 5334 Page Views: 

What is the difference between an explicit and an implicit lock?



Posted By: Avi Date: 25 July 2009 06:21:47 PM
 Answer:

Explicit Lock: Lock is explicitly requested for a record or table. Implicit Lock: Lock is implied but is not acquired.


Posted By: eTechPlanet


Date: 25 July 2009 06:21:47 PM

The difference between both of them is :

* Explicit Lock :- Lock is explicitly requested for a record or table.

* Implicit Lock :- Lock is implied but is not acquired.


Posted By: Johndecruse


Date: 10 February 2010 12:46:35 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image yDQ0bC
Related Questions
Database : Explain Data Integrity?

Explain Data Integrity?

Data integrity means the correctness and consistency of data. Enforcing data integrity ensures the q....
Category: Database Date: 10/7/2009 4:43:37 AM
Database : How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?

How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?

One-to-One relationship can be implemented as a single table and rarely as two tables with primary a....
Category: Database Date: 10/7/2009 2:51:09 AM
Database : What is Database Denormalization?

What is Database Denormalization?

Database denormalization is the reverse process of database normalization. Denormalization is the pr....
Category: Database Date: 10/7/2009 2:29:21 AM
Database : Explain Database Normalization?

Explain Database Normalization?

Database Normalization is a process to ensure that every non-key column in every table is directly d....
Category: Database Date: 10/7/2009 2:16:03 AM
Database : What is the use of commit command?

What is the use of commit command?

Commit command is used to make all the changes permanent to the underlying database which we made du....
Category: Database Date: 9/21/2009 9:51:29 PM
 
Find Best Deals @