Oracle Security in CDBs and PDBs - OCP: Oracle Database 12c Administrator Certified Professional - page 656

5. Which of the following is true regarding the CONTAINER clause?
A. CONTAINER=ALL is required when creating a common user.
B. CONTAINER=CURRENT is required when creating a common user.
C. CONTAINER=ALL is implied when creating a common user.
D. CONTAINER=CDB is the default for all common users.
E. None of the above
6. Local users have privileges to:
A. Access all objects in all PDBs.
B. Only local access to the PDB they were created in.
C. Share access with the same local username in another PDB, but only within the
same CDB.
D. The CDB$ROOT .
E. None of the above
7. When plugging a non-CDB into a PDB, what happens to the non-CDB users?
A. Oracle-supplied administrative user accounts overwrite the target PDB local
user accounts.
B. Oracle-supplied administrative user account passwords overwrite the target
common user account passwords.
C. Non-CDB defined user accounts become common user accounts in the target CDB.
D. Non-CDB defined user accounts become local user accounts in the target PDB.
E. None of the above
8. A local user can switch from PDB1 to PDB2 using which of the following
SQL*Plus commands?
A. ALTER USER SWITCH TO PDB2;
B. ALTER USER ENABLE PDB SWITCH;
C. ALTER SESSION SET CONTAINER=PDB2;
D. ALTER SESSION SET CONTAINER='PDB2';
E. None of the above
9. From an administrative perspective, which of the following is permitted when creating
new users? (Choose all that apply.)
A. Local users can create local users.
B. Common users can create local users.
C. Local users can create common users.
D. Common users can create common users.
E. All of the above