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.
The following command:
DROP PROFILE app_user CASCADE;
Leads us to choose the “B” option.
A is correct because:
Specify CASCADE to deassign the profile from any users to whom it is assigned. Oracle Database automatically assigns the DEFAULT profile to such users. You must specify this clause to drop a profile that is currently assigned to users.
Example
Dropping a Profile: Example The following statement drops the profile app_user, which was created in “Creating a Profile: Example”. Oracle Database drops the profile app_user and assigns the DEFAULT profile to any users currently assigned the app_user profile:
DROP PROFILE app_user CASCADE;
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_8026.htm
DROP PROFILE app_user CASCADE;