The DBA can modify the default locking mechanism by setting which init.ora parameter?
A . ROW_LOCKING=DEFAULT
B . ROW_LOCKING=TABLE
C . ROW_LOCKING=ROW
D. ROW_LOCKING=INTENT
Explanation:
Answer D: The DBA can modify the default locking mechanism by setting the ROW_LOCKING initialization parameter. The default value is ALWAYS; this causes default locking at the row level during DML statements. This is the least restrictive. You can also specify DEFAULT, which is synonymous with ALWAYS. Setting the value to INTENT causes default locking at the table level, except for SELECT...FOR UPDATE statements, which cause row-level locking.
No comments:
Post a Comment