【多选题】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, ...
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.
【多选题】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...
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.