Database Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 6003 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 muPKA4
Related Questions
Database : What is the difference between OLTP & OLAP?

What is the difference between OLTP & OLAP?

OLTP:- 1. It is based on entity relational model. 2. It inherits the concept of normalization so the....
Category: Database Date: 10/1/2010 11:14:07 AM
Database : What do you mean by OLTP?

What do you mean by OLTP?

OLTP means Online Transaction Processing systems which deals with relational database design and use....
Category: Database Date: 10/1/2010 11:13:07 AM
Database : How are Primary Key and Foreign key inter-related?

How are Primary Key and Foreign key inter-related?

Primary Key is a column or combination of columns to have unique records in the table. There can onl....
Category: Database Date: 10/1/2010 11:07:06 AM
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