大數據就業實戰培訓 Oracle就業實戰培訓
071考試題庫之前是比較穩定的，但隨著Oracle的調整，071考試不斷的增加新的考題，增加了考試的難度，所以我們專門收集整理了這些考試，并對這些考題進行解析，希望可以對考生有幫助。
每周五晚8點，我們有免費的OCP解析公開課，地址：https://ke.qq.com/course/326223 OCP題庫交流群：1015267481，驗證ocp
-------------------------------------------------------
071考試-第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
(解析：除了引用其他表的引用完整性約束之外，所有約束在表被閃回之后自動恢復，已經做過實驗)
