Oracle
1Z0-052 · Question #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_US
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #133. The question stem and answer options stay visible for context.
Administering User Security
Question
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?
Options
- AThe command produces an error.
- BThe profile is dropped and current user sessions use the DEFAULT profile immediately.
- CThe profile is dropped and only the subsequent user sessions use the DEFAULT profile.
- DThe profile is dropped, the sessions are terminated, and the subsequent user sessions use the
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#profiles#DROP PROFILE#active sessions#DEFAULT profile