---

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.

---

出自：Oracle认证

显示答案