Oracle
1Z0-883 · Question #24
What is true regarding InnoDB locking?
The correct answer is B. InnoDB only uses row locks, not page or table-level locks. See the full explanation below for the reasoning.
Question
What is true regarding InnoDB locking?
Options
- AInnoDB row locks may be escalated to page or table-level locks.
- BInnoDB only uses row locks, not page or table-level locks,
- CInnoDB uses row and table-level locks, but row locks are not escalates,
- DInnoDB locks only those rows that are updated.
- EInnoDB uses row-level or table-level locks depending on the number of rows affected.
How the community answered
(19 responses)- A5% (1)
- B84% (16)
- E11% (2)
Community Discussion
No community discussion yet for this question.