InterviewSolution
| 1. |
What Is A Lock? |
|
Answer» Lock is a mechanism provided by Oracle to reserve a DATABASE object so that different sessions do not interfere in each other's work. LOCKING helps in ensuring data consistency and maintaining database objects in USABLE state in a multi user environment. However, it can cause one session to block ANOTHER. Lock is a mechanism provided by Oracle to reserve a database object so that different sessions do not interfere in each other's work. Locking helps in ensuring data consistency and maintaining database objects in usable state in a multi user environment. However, it can cause one session to block another. |
|