试题详情
- 多项选择题 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
关注下方微信公众号,在线模考后查看
热门试题
- Which is
- 数据库必须拥有至少几个重做日志组()
- Given: 10. int
- Which is
- You are required to
- Mary has a view call
- You want to perform
- Which of
- Which two commands n
- In your database, y
- Which statement expl
- Given: What is
- ViewtheExhibittoexam
- 怎样取出在集合A中,但却不在集合B中的数
- Using Oracle
- 在数据库中,()使数据库程序无须对整个表
- Which SELECT stateme
- Your database has t
- 在循环语句中,退出循环体的关键字是()。
- In your d