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

Oracle认证考试

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

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

微信扫一扫手机做题