试题详情
单项选择题 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.

  • B

  • 关注下方微信公众号，在线模考后查看

热门试题