Which option would you use?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *