OCP-1Z0-051-V9.02-172题
来源:互联网 发布:linux find exec用法 编辑:程序博客网 时间:2024/05/17 03:17
172. The SQL statements executed in a user session are as follows:
SQL> CREATE TABLE product
(pcode NUMBER(2),
pname VARCHAR2(10));
SQL> INSERT INTO product VALUES (1, 'pen');
SQL> INSERT INTO product VALUES (2,'pencil');
SQL> SAVEPOINT a;
SQL> UPDATE product SET pcode = 10 WHERE pcode = 1;
SQL> SAVEPOINT b;
SQL> DELETE FROM product WHERE pcode = 2;
SQL> COMMIT;
SQL> DELETE FROM product WHERE pcode=10;
Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a
command in the session? (Choose two.)
A. The rollback generates an error.
B. No SQL statements are rolled back.
C. Only the DELETE statements are rolled back.
D. Only the second DELETE statement is rolled back.
E. Both the DELETE statements and the UPDATE statement are rolled back.
Answer: AB
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12885143
实验验证:
- OCP-1Z0-051-V9.02-172题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-11题
- OCP-1Z0-051-V9.02-12题
- OCP-1Z0-051-V9.02-14题
- OCP-1Z0-051-V9.02-15题
- OCP-1Z0-051-V9.02-17题
- OCP-1Z0-051-V9.02-18题
- OCP-1Z0-051-V9.02-21题
- OCP-1Z0-051-V9.02-118题
- OCP-1Z0-051-V9.02-120题
- OCP-1Z0-051-V9.02-32题
- OCP-1Z0-051-V9.02-33题
- OCP-1Z0-051-V9.02-93题
- OCP-1Z0-051-V9.02-94题
- OCP-1Z0-051-V9.02-95题
- 汉诺塔相关问题(1)
- 关于Android开发中的<include/>
- 触发器的简单update
- 移植OpenCV的AdaBoost人脸检测算法到DM6467
- MySQL概述
- OCP-1Z0-051-V9.02-172题
- 期望与目标
- 12299 - RMQ with Shifts
- 数组中连续最大和实现
- hdu 3277 Marriage Match III(二分最大流+并查集+判断满流+拆点)
- android.os.NetworkOnMainThreadException异常
- JSON.stringify 函数 (JavaScript)的声明和使用
- OCP-1Z0-051-V9.02-173题
- [公开课] 线性代数 学习记录1