Oracle 11G OCP 1Z0-053 43

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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1250228/，如需轉載，請註明出處，否則將追究法律責任。