Oracle 11G OCP 1Z0-052 162

（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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1225857/，如需轉載，請註明出處，否則將追究法律責任。