多选题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 tra

题目
多选题
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()
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.


相似考题
参考答案和解析
正确答案: B,C
解析: 暂无解析