【第9题】2019年OCP认证071考试题库大全

2019-05-21作者：hcjggs来源：www.hcjggs.com

近两年来，OCP的考试题库频率变化，不断的增加新考题，071考试就是其中一个，给很多考071的考生造成困扰，对此，我们专门整理了OCP考试里关于071考试的原题，并带上答案，分享给大家。

--------------------------------------------

9.choose two

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;

SQL> ROLLBACK TO SAVEPOINT a;

Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a command in the session?

A) Only the second DELETE statement is rolled back.

B) No SQL statements are rolled back.

C) Both the DELETE statements and the UPDATE statement are rolled back.

D) The rollback generates an error.

E) Only the DELETE statements are rolled back.

Answer：BD

(因为 commit 操作，前面所有的保存点都结束)

--------------------------------------------

OCP解析公开课时间：【每周五晚8点】

OCP解析群资料分享：1015267481 验证：ocp

另外，除了OCP公开课，OCM题库直播也同步进行中，OCM最新题库大爆料-【每周四晚8点】，【微信群直播】，可以联系咨询老师进群参与