当前位置： 071题库 > 【第7题】OCP认证1Z0-071最新考试题库及答案

【第7题】OCP认证1Z0-071最新考试题库及答案

来源：优技培训时间：

071考试不仅是OCP11g的考试科目，同时也是OCP 12c的考试科目，所以关心071考题的同学有很多，对此我们专门收集整理了近期071考试的原题，并对这些考题进行讲解，希望帮助广大考生顺利通过071考试。

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

7. choose the best answer

Evaluate the following SQL statement:

ALTER TABLE hr.emp

SET UNUSED (mgr_id);

Which statement is true regarding the effect of the above SQL statement?

A) Any views created on the EMP table that include the MGR_ID column would be automatically modified and remain valid.

B) Any constraints defined on the MGR_ID column would be removed by the above command.

C) Any synonym existing on the EMP table would have to be re-created.

D) Any index created on the MGR in column would continue to exist until the DROP UNUSED COLUMNS command is executed.

Answer：B

(注意：列一旦被设置为 unused 以后，基于该列的约束、索引都被删除，同时相关的视图被无法访问。)

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

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

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

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