单选题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 Sou

题目
单选题
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.


相似考题
参考答案和解析
正确答案: C
解析: 暂无解析