多选题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()
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.
相似考题