hardMultiple ChoiceObjective-mapped
FC0-U71 Practice Question: Refer to the exhibit
Exhibit
Refer to the exhibit. Database error log: ERROR: deadlock detected DETAIL: Process 1 waits for ShareLock on transaction 501; blocked by process 2. Process 2 waits for ShareLock on transaction 500; blocked by process 1. HINT: See server log for query details.
Refer to the exhibit. The database administrator sees this error in the log. Which action should the administrator take to resolve the deadlock?
⚠ Common exam trap
A common mix-up: candidates think manual intervention (killing a process) is required, but the exam tests the understanding that modern databases have automatic deadlock resolution built in, making option D the correct answer.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The database will automatically roll back one of the transactions; no immediate action is needed.
When a deadlock occurs in a database, the database management system (DBMS) automatically detects the circular dependency and selects one of the transactions as a victim, rolling it back to break the deadlock. This is a built-in mechanism in most relational databases, such as SQL Server, Oracle, or MySQL, and does not require manual intervention. Therefore, no immediate action is needed from the administrator, as the database will resolve the deadlock itself.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Increase the transaction isolation level to Serializable to prevent deadlocks.
Why it's wrong here
Increasing isolation can actually increase deadlock likelihood, not reduce it.
- ✗
Remove all indexes from the involved tables to reduce lock contention.
Why it's wrong here
Removing indexes typically causes full table scans, which can increase lock duration and deadlock risk.
- ✗
Manually kill one of the processes to break the deadlock.
Why it's wrong here
While possible, the database typically resolves deadlocks automatically by aborting one transaction. Manual intervention is not normally required.
- ✓
The database will automatically roll back one of the transactions; no immediate action is needed.
Why this is correct
Most DBMSs detect deadlocks and automatically choose a victim transaction to roll back.
Visual reference
Go deeper
Related to this question
About these practice questions
This FC0-U71 question is part of Courseiva's 988-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This FC0-U71 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the FC0-U71 exam.