The session of user SCOTT receives the following error after executing an UPDATE command on the EMP

最新推荐文章于 2016-01-24 11:52:23 发布
最新推荐文章于 2016-01-24 11:52:23 发布
阅读量815 收藏
点赞数
分类专栏： OCP 052
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/EVISWANG/article/details/50555757
版权
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. 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.



Correct Answer: BD

A:错误,收到死锁报错,scott用户的会话不会终止 

B:正确,一个会话提交或回滚,另一个会话可以继续事务 

C:错误,scott用户的会话不会自动rollback,需要人工处理 

D:正确, scott必须提交或回退,才能更正检测到的死锁错误.如果执行提交,则须重新提交第二 次更新才能完成事务处理.

如果执行回退,则须同时重新提交这两个语句才能完成事务处理

EVISWANG
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
The Landmarks of New York, Fifth Edition
01-04
The text has been based in part on the designation reports of the New York City Landmarks Preservation Commission. Initially, my assistants and I systematically gathered and catalogued each report. ...
OCP-1Z0-052-V8.02-172题
一抹曦阳-Oracle
10-13 9771
172. 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 in
OCP-1Z0-052-V8.02-185题
热门推荐
一抹曦阳-Oracle
10-24 1万+
185. User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp 2 WHERE job='CLERK' FO
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or a
EVISWANG的博客
01-24 750
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp 2 WHERE job='CLERK' FOR UPD
OCP 1Z0 052 172
有教无类的专栏
06-23 1307
172. 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 inv
The-STM32-receives-a-specific-string.zip_stm32 string_接收函数
09-23
STM32接收特定字符串,STM32中的库函数只能接收一个字节，如果需要接收多个字节，则需要自己写函数
Manipulating optical Tamm state in the terahertz frequency range with graphene
02-22
In this Letter, we demonstrate the physical mechanism of OTS at the interface between graphene and a dielectric Bragg mirror in the THz frequency band by applying the transfer matrix method and ...
prints out the corresponding digit on the telephone
03-08
Write a C++ function that receives a single letter and prints out the corresponding digit on the telephone. The letters and digits on a telephone are grouped this way: 2 = ABC 3 = DEF 4 = GHI 5 = JKL...
Discusses the computer network
05-19
Along with networking's swift development, the network security problem receives the attention day by day. This article in view of the influence network security's primary factor, has related in ...
50:Which two statements are true about alerts? (Choose two.) 选项 A.Clearing an alert sends the alert
EVISWANG的博客
01-21 2059
50:Which two statements are true about alerts? (Choose two.) 选项 A.Clearing an alert sends the alert to the alert history. B.Response actions cannot be specified with server-generated alerts. C.The
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the proce
EVISWANG的博客
01-21 1475
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users: CREATE OR REPLACE PROCEDURE create_dept( v_deptno NUMBER, v_dname VARCH
46: Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter
EVISWANG的博客
01-13 1366
46: Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.) 选项 A.The MTTR advisor will be disabled. B.Automatic checkpoint
Identify two situations in which the block header grows in a data block. (Choose two.) 选项 A.when ro
EVISWANG的博客
01-21 1296
Identify two situations in which the blockheader grows in a data block. (Choose two.) 选项 A.when row directories need more row entries B.when there is rowmigration in the data block C.when there is
You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPAC
EVISWANG的博客
01-21 1202
You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command? (Choose all that apply.) A. T
Which statement is true about loading data using the conventional path of SQL*Loader? A.Redo is not
EVISWANG的博客
01-24 1149
Which statement istrue about loading data using the conventional path of SQL*Loader? A.Redo is notgenerated while performing conventional path loads. B.Only PRIMARY KEY,UNIQUE KEY, and NOT NULL cons
Your database instance is running with full workload after database creation. You have decided to us
EVISWANG的博客
01-21 1147
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the u
Which three statements are correct about temporary tables? (Choose three.) A. Indexes and views can
EVISWANG的博客
01-21 1113
Which three statements are correct about temporary tables? (Choose three.) A. Indexes and views can be created on temporary tables B. Both the data and structure of temporary tables can be exported
You want to configure and schedule offline database backups to run automatically. Which tool or util
EVISWANG的博客
01-21 1110
You want toconfigure and schedule offline database backups to run automatically. Whichtool or utility wouldyou use to achieve this? A.the XML script B.the PL/SQL script C.the DBMS_SCHEDULER packag
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database i
EVISWANG的博客
01-21 1059
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups
The number of columns of the signal input must be equal to the number of transmit antennas.
最新发布
06-10
This error message usually occurs in a MIMO (multiple-input, multiple-output) communication system when there is a mismatch between the number of transmit antennas and the dimensions of the input ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值