---

The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock.  Which two statements are true regarding the session ofSCOTT in this scenario（）
A:The session is terminated after receiving the error and JIM can continue with his transaction.
B:SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C:The session is rolled back after receiving the error and JIM can continue with his transaction.
D:SCOTT has to reexecute the last command in the transaction after he commits the transaction.

---

出自：Oracle认证

显示答案