Oracle
1Z0-873 · Question #138
Which of the following describes how deadlocks may occur and how InnoDB resolves them?
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.
Transactions and Locking
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.
Topics
#InnoDB deadlocks#transaction locking#lock resolution#InnoDB storage engine