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 archiver (ARCn)?
- What are bind variables?
- What is a cluster ?
- What is TKPROF utility?
- What is ALTER SESSION statement?