（43）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.