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 not possible because it has conflicts with transaction T3.
B.
It is possible with the NONCONFLICT_ONLY option.
C.
It is possible with the NOCASCADE_FORCE option.
D.
It is possible, but transaction T3 also backs out.