请教!
请问Recovery Manager (RMAN) backups would be inconsistent. 对吗?为什么?
150. The session of user SCOTT receives the following error after executing an UPDATE command on the 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.
Which two statements are true regarding the session of SCOTT in this scenario? (Choose two.)
A) It is terminated after receiving the error and JIM can continue with his transaction.
B) The transaction in it is terminated after receiving the error and JIM can continue with his transaction.
C) SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
D) SCOTT has to reexecute the last command in the transaction after he commits the transaction.
这个c对吗?不是jim执行的时候产生deadlock了吗?怎么是scott执行commit和rollback呢?
[ 本帖最后由 tiancaiha 于 2008-9-12 13:21 编辑 ]
|