The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock. two statements are true regarding the session of SCOTT in this scenario()
- AThe session is terminated after receiving the error and JIM can continue with his transaction.
- BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
- CThe session is rolled back after receiving the error and JIM can continue with his transaction.
- DSCOTT has to reexecute the last command in the transaction after he commits the transaction.