052 -- drop profile app_user, ocp052 --
133. You created a profile APP_USER and assigned it to the users. After a month, you decide to drop
Profile. Some user sessions are currently connected to the database instance and are using
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
DEFAULT profile.
Answer:
[Resolution]
Create profile profile1 LIMIT;
Alter user scott PROFILE profile1;
-- Check that SCOTT's default profile changes to: profile1.
SYS @ orcl> drop profile profile1;
Drop profile profile1
*
Row 3 has an error:
ORA-02382: Profile PROFILE1 specifies the user and cannot be deleted without CASCADE
SYS @ orcl> drop profile profile1 cascade;
The configuration file has been deleted.
-- After profile1 is deleted, scott's default profile is automatically changed back to default
The answer is clear!
Oracle Database 11g (1Z0-051, 1Z0-052, 1Z0-053) Full Oracle Database 11g (OCP/OCA certification test Guide)
The ocp test must go to the original factory or WDP, and it is best not to go to many affiliated companies, because oracle does not participate in training, even if the test is passed, no certificate is issued. It is better to go to WDP, and the cost is also cheap ~ There are also 23 days of pre-examination training, which is very helpful. WDP organizations can be found on the oracle official website, CUUG is good, the ocp ocm are all here.
Kneeling oracle 11g OCA, OCP information, 1Z0-051, 1Z0-052, 1Z0-007, 1Z0-047, my email address 347133036 @ qqcom
Only learning or taking the test? If you want to take the exam, you must go to the authorized institution for training to get the exam number. Official certification is now 10 Gb, we do not have 11 GB of information, 10 Gb can go to our website to download, the website knows can not answer, so you can only go to my information to find.
Chengdu Yinhe Education Center
Address: No. 288 taisheng South Road, Qingyang District, Chengdu, Sichuan