Multiple choice technology databases

What is the best way for a deadlock to be resolved?

  1. All statements are removed and have to be resubmitted

  2. The Oracle server rolls back the statement that detected the deadlock

  3. The administrator has to kill the session

  4. Deadlocks can not be resolved
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle automatically detects deadlocks and resolves them by rolling back the specific statement that caused the deadlock, allowing other transactions to proceed. Manual intervention or killing the entire session is usually not required for basic resolution.

Keep practicing — related questions