What is the best way for a deadlock to be resolved?
All statements are removed and have to be resubmitted
The Oracle server rolls back the statement that detected the deadlock
The administrator has to kill the session
Deadlocks can not be resolved