nerdexam
Oracle

1Z0-873 · Question #138

1Z0-873 Question #138: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-873 to reveal the answer and full explanation for question #138. The question stem and answer options stay visible for context.

Question

Which of the following describes how deadlocks may occur and how InnoDB resolves them?

Options

  • ADeadlocks happen anytime when more than one lock is placed in a table.
  • BDeadlocks happen when two transactions both have locks that the other is waiting for the release
  • CInnoDB resolves deadlocks by terminating and rolling back one of the deadlocking transactions.
  • DInnoDB resolves deadlocks by terminating and rolling back both of the deadlocking transactions.

Unlock 1Z0-873 to see the answer

You've previewed enough free 1Z0-873 questions. Unlock 1Z0-873 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-873 Practice