what are different types of locks?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / jakki

6 Answers
6671 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are different types of locks?..

Answer / raj

There is two types of lock .
share and exclusive.

Is This Answer Correct ?

4 Yes

1 No

what are different types of locks?..

Answer / bibhuti bhusan patra

implicit locks & explicit locks
implicit locks are maintained by oracle internally.
&explicit locks are performed by user manualy.

Is This Answer Correct ?

1 Yes

0 No

what are different types of locks?..

Answer / shanmugavelu

row level and table level locks,
dont try share update lock its failure in table lelvel ..

Is This Answer Correct ?

1 Yes

1 No

what are different types of locks?..

Answer / pratap dixit

Pessimistic and Optimistic lock
Pessimistic- at the time of reading , locking the row
Optimistic- at time of updating , locking the row.

Is This Answer Correct ?

0 Yes

0 No

what are different types of locks?..

Answer / a.brahmam

mainly two types of locks
1.Row Level Locks
2.Table Level Locks

Table Level Locks Are Two Types
-------------------------------------------------
1.Share Lock
2.Exclusive Lock

Is This Answer Correct ?

0 Yes

0 No

what are different types of locks?..

Answer / yogesh babu

I think it is the read & write locks

Is This Answer Correct ?

1 Yes

4 No

Post New Answer