OCP solves the problem 052--DROP profile App_user

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 is currently connected to the database instance and is using the
App_user profile.
This command was used to drop the profile:
sql> DROP profile App_user;

Which statement describes the result?
A. The command produces an error.
B. The profile was dropped and current user sessions use the DEFAULT profile immediately.
C. The profile was dropped and only the subsequent user sessions use the DEFAULT profile.
D. The profile is dropped, the sessions was terminated, and the subsequent user sessions use the
DEFAULT profile.

Answer:a

Resolution

CREATE profile Profile1 LIMIT;
ALTER USER Scott profile Profile1;

--See user Scott's default profile changed to: Profile1

[email protected]> Drop profile profile1;
Drop Profile Profile1
*
An error occurred on line 1th:
ORA-02382: Profile PROFILE1 specified user, cannot be deleted without CASCADE

[email protected]> Drop profile profile1 cascade;

The configuration file has been deleted.

When--profile1 is removed, Scott's default profile changes itself back to default

The answer is at a glance!

Copyright notice: This article blog original article. Blogs, without consent, may not be reproduced.

OCP solves the problem 052--DROP profile App_user