Database Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 5886 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 G7yhpU
Related Questions
Database : What is the purpose of Triggers?

What is the purpose of Triggers?

Triggers are some set of business rules. It consist of some set of commands or statements like Store....
Category: Database Date: 10/1/2010 10:59:06 AM
Database : What is DKNF?

What is DKNF?

DKNF is one of the Normalization forms. It is Domain-Key Normal Form(DKNF). According to this normal....
Category: Database Date: 10/1/2010 10:58:06 AM
Database : Why is De-normalisation Required?

Why is De-normalisation Required?

Fully normalized database can only be attained at logical level. Truly normalized databse can not be....
Category: Database Date: 10/1/2010 10:57:06 AM
Database : What do you mean by normalization?

What do you mean by normalization?

Basically normalization is a process in realational databse design to organise the data and avoid da....
Category: Database Date: 10/1/2010 10:56:06 AM
Database : I have 1-year gap between my 10th & 12th. So what should I answer regarding this?