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

最新推荐文章于 2020-03-10 14:12:42 发布

原创最新推荐文章于 2020-03-10 14:12:42 发布 · 114 阅读

0 ·

CC 4.0 BY-SA版权

本文详细解析了在Oracle数据库中如何回滚特定的事务，尤其是在存在冲突事务的情况下。通过使用NOCASCADE_FORCE选项，可以强制回滚指定的事务，而忽略其依赖的事务，为数据库管理员提供了强大的数据恢复手段。

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.youkuaiyun.com/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

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.