Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
What Is a Data Lock in Oracle?
Answer:
A data lock is logical flag the Oracle server is placed on data objects to give an exclusive right to a transaction. Statements in other transactions needs to respect data locks based on certain rules. Rules on data locks are:
► SELECT query statements do not create any data locks.
► INSERT, UPDATE, and DELETE statements create data locks on the affected rows.
► Data locks are released when the owner transaction ends.
► SELECT query statements do not create any data locks.
► INSERT, UPDATE, and DELETE statements create data locks on the affected rows.
► Data locks are released when the owner transaction ends.
Download Oracle Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What Are Transaction Isolation Levels Supported by Oracle? | How Data Locks Are Respected in Oracle? |