Pessimistic concurrency control Optimistic concurrency control

What are the two types of concurrency?

Question Posted / s.vanitha

Answer Posted / s.vanitha

Pessimistic concurrency control
Optimistic concurrency control

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to write a query with a right outer join in ms sql server?

896

What are the different types of sql server replication? : sql server replication

1237

What is xdr?

968

How do I start sql server 2016?

878

How to use clusters?

919

How to insert data into an existing table?

960

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

935

What are difference between Cluster index and Non-Cluster index?

1058

What encryption security is available in sql azure?

101

What is the need for group functions in sql?

1053

What are the database roles? : sql server security

1145

What is a benefit of using an after insert trigger over using a before insert trigger?

966

How to create new table with "create table" statements?

1066

How do I connect to sql server database?

995

How do you handle datasets larger than 50 gb?

162