试题详情
- 多项选择题 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
关注下方微信公众号，在线模考后查看
热门试题
- 下列选项中，能够解除HR用户的锁定的语句
- Which two statements
- YouplantouseFlashbac
- 假设需要在数据库中创建角色test_ro
- A Mysql instance is
- An application
- In your d
- Identify the&e
- Examine the&en
- The warning&en
- Given： and two
- You have
- RMAN automatic
- You have
- Evaluatethefollowing
- You want to display
- 在Oracle中，（）是一个基于Web的
- （）是Oracle最高一级逻辑存储结构。
- Automatic Shar
- Your database&