ocp-v13-043
来源:互联网 发布:上帝软件wpe1.0 编辑:程序博客网 时间:2024/06/03 21:15
QUESTION 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.
Correct Answer: B
查看下面的SQL语句:
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;
你想退出事务T2。你会使用哪个选项?
B.这是可能的nocascade_force选项。
- ocp-v13-043
- OCP-V13-676
- OCP-V13-711
- OCP-V13-710
- OCP-V13-709
- OCP-V13-708
- OCP-V13-707
- OCP-V13-705
- OCP-V13-704
- OCP-V13-703
- OCP-V13-702
- OCP-V13-701
- OCP-V13-700
- OCP-V13-700
- OCP-V13-699
- OCP-V13-698
- OCP-V13-697
- OCP-V13-696
- OCP-V13-042
- C++按格式接收输入字符(京东,滴滴,360笔试必用)
- android控件:WebView的初使用
- 系统学习ARM之五 --C语言和汇编混合编写
- C语言第八节-文件操作
- ocp-v13-043
- 关于Android Studio无法预览的问题
- 数组排序 -- 2015/9/28
- HDU5490 Simple Matrix
- Cocoapods配置第三方类库教程
- IBM超能云性能测试
- ocp-v13-044
- 规范变换
- C语言项目总结-通讯录