问题:
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.
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?()
● 参考解析
本题暂无解析
相关内容
相关标签