OCP试题解析之052-- DROP PROFILE app_user，ocp052--
133.You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the
profile. Some user sessions are currently connected to the database instance and are using the
APP_USER profile.
This command is used to drop the profile:
SQL> DROP PROFILE app_user;
Which statement describes the result?
A. The command produces an error.
B. The profile is dropped and current user sessions use the DEFAULT profile immediately.
C. The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
D. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the
DEFAULT profile.
Answer: A
【解析】
CREATE PROFILE profile1 LIMIT;
ALTER USER scott PROFILE profile1;
--此时查看用户SCOTT的default profile变为：profile1
SYS@orcl> drop profile profile1;
drop profile profile1
*
第 1 行出现错误:
ORA-02382: 概要文件 PROFILE1 指定了用户, 不能没有 CASCADE 而删除
SYS@orcl> drop profile profile1 cascade;
配置文件已删除。
--profile1删除后，scott的default profile自动变回default
答案一目了然！
ocp考试一定要去原厂或WDP，很多挂靠的最好别去，因为oracle规定不参加培训，就算考过了也不发证书的。去WDP比较好，费用也便宜~还有23天的考前培训，很有帮助的。WDP的机构你可以上oracle官网查到，CUUG不错，考ocp ocm的都是去这里 。
只是学习还是需要参加考试？如果需要参加考试，必须到授权机构经过培训才能拿到考试号的。官方认证现在是考10g，我们没有11g的资料，10g的可以到我们网站上面去下载，网址知道不能回答，所以你只能到我资料去找下。
成都银河教育中心
地址：四川成都市青羊区太升南路288号锦天国际C座1506鐧惧害鍦板浘