多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题