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.