What are DML locks?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are DML locks?
Rating:
DML locks are used for locking tables while performing DML operations (INSERT, UPDATE, and DELETE) on them. DML locks ensure that only a single operation is performed on a row at a time. This helps in maintaining data consistency. DML locks are maintained at two levels:
- Table level
- Row level
Rating:
Was this information helpful?
Other articles
- What is Program Global Area (PGA)?
- What is resource plan directive?
- How does Database Resource Manager perform database resource management?
- What is Workload class?
- What are locks?