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
查看下面的SQL语句，你要退出事务T2。你会用哪一个选项？
可能是用NOCASCADE_FORCE(强制无级联)选项。
NONCONFLICT_ONLY（这里region_id = 5有冲突）
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
查看下面的SQL语句，你要退出事务T2。你会用哪一个选项？
可能是用NOCASCADE_FORCE(强制无级联)选项。
NONCONFLICT_ONLY（这里region_id = 5有冲突）
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2122877/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q42
下一篇：
1Z0-053 V13.02 Q45
请登录后发表评论
登录
全部评论
