DML lock is also known as _______.

Options
- Dictionary lock
- Data lock
- Internal lock
- Disturbed lock


CORRECT ANSWER : Data lock

Discussion Board
DML lock

DML lock is also known as data lock, is to guarantee the integrity of data being accessed concurrently by multiple users. For example, a DML lock can prevent multiple customers from buying the last copy of a book available from an online bookseller. DML locks prevent destructive interference of simultaneous conflicting DML or DDL operations. DML statements automatically acquire locks at both the table level and the row level.

Prajakta Pandit 03-3-2017 12:06 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement