nerdexam
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)
  • A
    5% (1)
  • B
    84% (16)
  • E
    11% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice