OCP試題解析之052-- DROP PROFILE app_user

標籤：drop profile   ocp   

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

[email protected]> drop profile profile1;
drop profile profile1
*
第 1 行出現錯誤:
ORA-02382: 概要檔案 PROFILE1 指定了使用者, 不能沒有 CASCADE 而刪除

[email protected]> drop profile profile1 cascade;

設定檔已刪除。

 

--profile1刪除後，scott的default profile自動變回default

 

答案一目瞭然！

 

 

 

 

 

 

OCP試題解析之052-- DROP PROFILE app_user