162.You created a profile APP_USER and assigned it to the users. After a month, you decide to drop t

162.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.
答案：A
解析：profile分配给用户后，必须取消才可以删除profile文件
--创建profile
SQL> create profile wwww limit failed_login_attempts 7; 
Profile created.

--指定profile
SQL> alter user skd profile wwww;
User altered.

--查看skd的profile
SQL> select PROFILE from dba_users where username='SKD';
PROFILE
------------------------------
WWWW
--测试删除，删除失败
SQL> drop profile wwww;
drop profile wwww
*
ERROR at line 1:
ORA-02382: profile WWWW has users assigned, cannot drop without CASCADE

--修改为默认的profile
SQL> alter user skd profile default;
User altered.
--测试删除，删除成功
SQL> drop profile wwww;
Profile dropped.