View these SQL statements: 　　Transaction T1 　　INSERT INTO hr.reg

View these 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; 　　Your requirement is to back out transaction T2. 　　What is the possibility?

A.It is not possible because transaction T2 conflicts with transaction T3.

B.It is possible with the NONCONELICT_ONLY option.

C.It is possible, but transaction T3 would also be backed out.

D.It is possible with the NOCASCADE_FORCE option.

正确答案是C