Different Types of Locks are 1. Shared Lock 2. Exclusive Lock 3

What is a Lock and let me know Different types of locks?

Question Posted / sreejith s t

Answer Posted / sreejith s t

Different Types of Locks are
1. Shared Lock
2. Exclusive Lock
3. Update Lock

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can we solve concurrency problems?

1058

Does partitioning improve performance sql server?

983

How to execute multiple stored procedures at one time in sql server?

1015

What is lock escalation and what is its purpose?

975

What is sql server management studio? : sql server management studio

1080

What are the different editions available in sql server 2000?

1052

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

can an automatic recovery be initiated by a user? : Sql server administration

956

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

998

How can you append an identity column to a temporary table?

954

Does table partitioning improve performance?

974

What are the advantages of using a stored procedure?

1008

Explain about Joins?

997

How to download and install sql server 2005 books online?

1193

What is the temp table?

928