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
这里是FLASHBACK Transaction特性的知识点:
过程:DBMS_FLASHBACK.TRANSACTION_BACKOUT
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 either COMMIT the changes or else ROLL BACK .
参考: https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_flashb.htm
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
这里是FLASHBACK Transaction特性的知识点:
过程:DBMS_FLASHBACK.TRANSACTION_BACKOUT
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 either COMMIT the changes or else ROLL BACK .
参考: https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_flashb.htm
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-2074467/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8520577/viewspace-2074467/