2018年OCP 11g考試原題解析已經講解30多次課，500多道考試原題，最終達到98%以上的考題覆蓋度及95%以上的考試通過率。

2019年OCP 11g將升級到12c，OCP 12c考試解析免費公開課也已經開始了，歡迎大家收看!

OCP解析公開課時間：【每周五晚8點】

OCP解析公開課地址：http://ke.qq.com/course/326223

OCP解析群資料分享：1015267481 驗證：ocp

另外，除了OCP公開課，OCM題庫直播也同步進行中，OCM最新題庫大爆料-【每周四晚8點】，【微信群直播】，可以聯系咨詢老師進群參與

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

14.choose the best answer

View the Exhibit and examine the data in EMP and DEPT tables.

In the DEPT table, DEPTNO is the PRIMARY KEY.

In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY referencing

the DEPTNO column in the DEPT table.

What would be the outcome of the following statements executed in the given sequence?

DROP TABLE emp;

FLASHBACK TABLE emp TO BEFORE DROP;

INSERT INTO emp VALUES (2,'SCOTT', 10);

INSERT INTO emp VALUES (3,'KING', 55);

A) Both the INSERT statements would succeed because none of the constraints on the table are automatically retrieved when the table is flashed back.

B) Only the second INSERT statement would succeed because all the constraints except referential integrity constraints that reference other tables are retrieved automatically after the table is flashed back.

C) Both the INSERT statements would fail because all constraints are automatically retrieved when the table is flashed back.

D) Only the first INSERT statement would succeed because all the constraints except the primary key constraint are automatically retrieved after a table is flashed back.

Answer：B

(解析：除了引用其他表的引用完整性約束之外，所有約束在表被閃回之后自動恢復，已經做過實驗)