Exam 1z0-083 topic 1 question 48 discussion

for me AD is correct.

A and D For the common user: The username must be unique across all containers. So D is correct because APP_USER1 is different from APP1_USER1 in APP1_ROOT B,E are wrong because you can only create local user in specific PDB. A is true because APP1_USER1 is unique in PDB1 F is false because common user will not have the same privileges and role unless you grant it with option CONTAINER=ALL;

C can be done, as you technically are able to sync a different version of the application to every application PDB.

A,C. The letter D makes no sense, c##_app1 can be created at ANY TIME in cdb1, even without installing the patch in the approt

ACD are all correct

for me A+D is correct.

A. APP1_USER1 can be created in PDB1. - Correct. It can be created - Tested B. APP1_USER1 can be created in CDB1. - Wrong. It must be a common user to be created in the CDB1 C. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT. - Correct - You can grant differen privilege to a local user on application pdbs D. C##_APP_USER1 can be created in CDB1. - Correct. It has the common user prefix, but make no sense. E. P1_USER1 can be created in CDB1. - Wrong. It must be a common user to be created in the CDB1 F. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1. - Wrong. It may have different privileges in PDBs in CDB1 In my opinion there are three correct answers in this question: A C D

Answer: AC D and F: C##_ not C## B and E: common users in CDB

I think C is correct, becouse when you sync the PDB application, the user is created and we can grant whatever privilege we want, even in the next sync the privileges remaing forever until explicit revoke.

Is F wrong because the user created was C##USER1 and not C##_USER1?

C and F A ---PDB1 is pluggable db but APP1_USER1 is being created in App1_root not pdb B-- again the user is being created in application database not CDB

very strange question for me, do they mean 'has been created' instead of can... B,E for sure incorrect due to c## prefix

DF for me

C and F looks ok. A,B - APP1_USER1 is a local user and from output is created in app1_cdb1_app and not in PDB1 or CDB1 D - C##_APP_USER1 there is nothing about such user in output E - P1_USER1 - based on the output, is a user created in PDB1. If try from CDB: SQL> create user app1_user2 identified by oracle_4U; create user app1_user2 identified by oracle_4U * ERROR at line 1: ORA-65096: invalid common user or role name SQL>

ACD all should work. E is not true, because of the prefix issue others also are not true, which is checked on 19c

its possible to create normal user in CDB? i think always we need create user like in CDB user C## prefix

for me E F are correct