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.
正确答案:B,D
答案解析:有
微信扫一扫手机做题