OCP-1Z0-053-V13.02-43题

回滚特定事务

最新推荐文章于 2022-07-18 17:24:21 发布

原创最新推荐文章于 2022-07-18 17:24:21 发布 · 1w 阅读

1 ·

CC 4.0 BY-SA版权

OCP11g解析同时被 2 个专栏收录

870 篇文章

订阅专栏

OCP-1Z0-053

796 篇文章

订阅专栏

本文探讨了在存在依赖事务的情况下如何回滚指定的事务T2，介绍了使用NOCASCADE_FORCE选项来强制回滚的方法，并解释了该操作的具体流程。

43.View the following SQL statements:

Transaction T1 INSERT INTO hr.regions VALUES (5,'Pole');COMMIT;

Transaction T2 UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5; COMMIT;

Transaction T3 UPDATE hr.regions SET region_name='North and South Poles' WHERE region_id = 5;

You want to back out transaction T2. Which option would you use?

A. It is possible, but transaction T3 also backs out.

B. It is possible with the NOCASCADE_FORCE option.

C. It is possible with the NONCONFLICT_ONLY option.

D. It is not possible because it has conflicts with transaction T3.

Answer: B

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS627

NOCASCADE_FORCE - The user forcibly backs out the given transactions without considering the dependent transactions. The RDBMS executes the UNDO SQL for the given transactions in reverse order of their commit times. If no constraints break, and the result is satisfactory, the user can eitherCOMMIT the changes or else ROLL BACK.

NOCASCADE_FORCE

Backs out specified transactions, ignoring dependent transactions. Server runs undo SQL statements for specified transactions in reverse order of commit times.

If no constraints break and you are satisfied with the result, you can commit the changes; otherwise, you can roll them back.