172.The session of user SCOTT receives the following error after executing an UPDATE command on the

172.The session of user SCOTT receives the following error after executing an UPDATE command on
the 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.
Which two statements are true regarding the session of SCOTT in this scenario? (Choose two.)
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.
答案：BD
解析：这个是说死锁，oracle会检测到死锁，并将对应的信息写入alert.log日志文件
发生死锁后，出现错误日志的用户，必须提交或者回滚事务，才可以将占用的资源释放掉，这样jim才可以继续
参考：http://docs.oracle.com/cd/E11882_01/server.112/e40540/consist.htm#CNCPT221