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

最新推荐文章于 2023-08-16 20:49:05 发布
最新推荐文章于 2023-08-16 20:49:05 发布
阅读量834 收藏
点赞数
分类专栏： 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
关注
专栏目录
遇到问题--mac下MySQL8使用mysqlimport出现The used command is not allowed with this MySQL version
直到世界的尽头
11-07 1281
情况 使用mysqlimport命令把csv文件导入到mysql中，报错如下： zhangxiaofans-MacBook-Pro:aws-money-result joe$ mysqlimport --ignore-lines=1 --fields-terminated-by=, --user=root --password=12345678 -h 127.0.0.1 -P 3306 -...
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or a
EVISWANG的博客
01-24 777
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-V8.02-172题
一抹曦阳-Oracle
10-13 9793
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
172.The session of user SCOTT receives the following error after executing an UPDATE command on the
dwj19830118的专栏
08-08 757
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 investigation, you find that a session opened by user JIM has a trans
Oracle10gOCP042题库71120题共168题
绿杨
04-17 502
原 Oracle 10g OCP 042 题库 71-120 题 共168题https://blog.csdn.net/tianlesoftware/article/details/5774253版权声明： https://blog.csdn.net/tianlesoftware/article/details/5774253 71. Your database instance is start...
oracle 认证 042
wolf
02-07 2286
1.Which three pieces of information are considered while deciding the size of the undo tablespace in your database? (Choose three.) A:the size of an undo block B:the size of the redo log files C:u
ocp052 2019-03
tzm84109的博客
05-20 830
ocp052 2019-03 QUESTION 1 You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.) A. Disable automatic checkpoi...
Oracle 10g OCP 042 题库 71-120 题 共168题
润明--oracle--unix-IT技术专栏
02-03 2641
Oracle 10g OCP 042 题库 71-120 题 共168题   author:润明 2012-2-3  QQ:226399587  http://blog.csdn.net/runming918 71. Your database instance is started using the server parameter file (SPFILE). Control fil
oracle11g OCP 认证 1Z0-052考试笔记2
wlbzy的专栏
11-16 4841
Q1  View the Exhibit and identify the component marked with a question mark. A.Checkpoint (CKPT) Q2. Sunday An incremental level 0 backup backs up all blocks that have ever been in use in this da
The-STM32-receives-a-specific-string.zip_stm32 string_接收函数
09-23
STM32是一款基于ARM Cortex-M内核的微控制器，广泛应用于嵌入式系统设计。在进行串行通信时，我们经常需要...文件"The STM32 receives a specific string.doc"可能包含了更详细的实现细节和示例代码，供你参考和完善。
Using Python and the Twitter API to Automate Tweets
最新发布
AI天才研究院
08-16 1203
作者：禅与计算机程序设计艺术 1.简介 Twitter has become one of the most popular social media websites in recent years. Its popularity is increasing at an exponential rat
Receive the ages of the all your family members (between 3 to 6 members) as command line arguments in the format as following (name then age) Monica 12 Daniel 34 Shelley 23 in java
05-24
Here's an example Java program that receives the names and ages of family members as command line arguments: ```java public class FamilyAges { public static void main(String[] args) { // Check if ...
50:Which two statements are true about alerts? (Choose two.) 选项 A.Clearing an alert sends the alert
EVISWANG的博客
01-21 2087
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 1504
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 1385
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 1313
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 1230
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 1182
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
A function that receives a LIST as an argument and returns the LIST in reverse.
04-07
As an AI language model, I don't have the capability to write code in a specific programming language. However, I can provide you with the general algorithm for reversing a list: 1. Create an empty list to store the reversed elements. 2. Iterate through the original list in reverse order, starting from the last element. 3. Append each element to the new list. 4. Return the new list. Here's an example implementation in Python: ``` def reverse_list(lst): reversed_lst = [] for i in range(len(lst)-1, -1, -1): reversed_lst.append(lst[i]) return reversed_lst ``` This function takes a list `lst` as an argument and returns a new list with the elements in reversed order. The `range()` function is used to iterate through the original list in reverse order, starting from the last index (`len(lst)-1`) and ending at the first index (`-1`) with a step of `-1`. The `append()` method is used to add each element to the new list. Finally, the reversed list is returned.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值