What Are The Different Types Of Locks?

1.	What Are The Different Types Of Locks?
Answer» Read lock (shared lock): Protects read access to an object. The read lock allows other transactions read access but not write access to the locked AREA of the table. Write lock (exclusive lock): Protects write access to an object. The write lock allows other transactions NEITHER read nor write access to the locked area of the table. ENHANCED write lock (exclusive lock WITHOUT cumulation): Works like a write lock except that the enhanced write lock also protects from further ACCESSES from the same transaction. Read lock (shared lock): Protects read access to an object. The read lock allows other transactions read access but not write access to the locked area of the table. Write lock (exclusive lock): Protects write access to an object. The write lock allows other transactions neither read nor write access to the locked area of the table. Enhanced write lock (exclusive lock without cumulation): Works like a write lock except that the enhanced write lock also protects from further accesses from the same transaction.

Answer»

Read lock (shared lock):

Protects read access to an object. The read lock allows other transactions read access but not write access to the locked AREA of the table.

Write lock (exclusive lock):

Protects write access to an object. The write lock allows other transactions NEITHER read nor write access to the locked area of the table.

ENHANCED write lock (exclusive lock WITHOUT cumulation):

Works like a write lock except that the enhanced write lock also protects from further ACCESSES from the same transaction.

Read lock (shared lock):

Protects read access to an object. The read lock allows other transactions read access but not write access to the locked area of the table.

Write lock (exclusive lock):

Protects write access to an object. The write lock allows other transactions neither read nor write access to the locked area of the table.

Enhanced write lock (exclusive lock without cumulation):

Works like a write lock except that the enhanced write lock also protects from further accesses from the same transaction.

Discussion