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


Correct Option: B

Find more quizzes: