Managing Oracle Multitenant Databases - OCP: Oracle Database 12c Administrator Certified Professional - page 580

Review Questions
1. In the Oracle 12 c multitenant architecture, a common user has access to which PDBs
and CDBs?
A. All PDBs and all CDBs
B. The current PDB and CDB
C. All PDBs and the CDB$ROOT container
D. CDB$ROOT and PDB$SEED
E. All of the above
2. Which of the following statements is true regarding a local user?
A. A local user is created at the CDB$ROOT .
B. A local user has access to the CDB$ROOT and the local PDB.
C. A local user has access to all PDBs but not the CDB$ROOT .
D. A local user has access to only the local PDB.
3. Which of these formats represents the correct command to create a common user in
S Q L*P l u s ?
A. CREATE COMMON USER C##cdbuser
IDENTIFIED BY cdbuser
CONTAINER = ALL;
B. CREATE USER c##cdbuser
IDENTIFIED BY cdbuser
CONTAINER = CDB$ROOT;
C. CREATE USER c##cdbuser
IDENTIFIED BY cdbuser
CONTAINER = ALL;
D. None of the above
4. To create a local user in the PDB1 container, which of the following must be true?
A. The user creating the local user must also be a local user.
B. The user creating the local user must be a common user and have CREATE USER
privileges.
C. The local username must be unique across all PDBs within the CDB.
D. The local user must be created by a DBA with access to all PDBs.
E. None of the above