多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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,D
答案解析:
进入题库查看解析

微信扫一扫手机做题