- 搜標(biāo)題
- 搜題干
- 搜選項(xiàng)
單項(xiàng)選擇題
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.
你可能感興趣的試題
