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.
正确答案:B
答案解析:有

微信扫一扫手机做题