Answers to Review Questions - OCP: Oracle Database 12c Administrator Certified Professional - page 680

Chapter 11: Creating Oracle
Multitenant Databases
1. D. A many-to-one relationship exists between PDBs and the CDB.
2. B. The seed PDB plus 252 user-created PDBs are allowed per CDB.
3. B. Options A and C use incorrect terms PDB and SYSTEM .
4. E. The Oracle multitenant architecture is available beginning with Oracle 12 c Release 1
(12.1), supports multiple PDBs within a single CDB on a given platform, allows the DBA
to shut down tenant PDBs while keeping the host CDB active, and supports multiple
PDBs of the same release of Oracle within the same CDB.
5. B, D, E. CDB$SEED and PDB$ROOT do not exist.
6. D. All other options are invalid.
7. A, B, C. Option D is incorrect because the multitenant architecture does not offer
platform independence.
8. A, C, E. Option B is incorrect because not all 12 c databases are non-CDBs. You can
create a CDB that contains only the PDB$SEED database, so D is incorrect.
9. A, B, C, D. Option E is incorrect; you cannot move a CDB into a PDB.
10. D. Option D is the only valid clause that can be used to create a container database.
11. E. Once you create an Oracle 12 c database as a non-CDB, you can't alter it to become
a CDB.
12. B. The supplied script catcdb.sql adds the necessary dictionary objects to enable
container database provisioning.
13. A. Option A is the only correct navigation sequence in the Database Configuration
Assistant (DBCA).
14. B. Option A is incorrect because you have not specified a source PDB. Option C is
incorrect because when you create a new PDB from PDB$SEED , you must specify an
administrator username and password for the new PDB in the CREATE PLUGGABLE
DATABASE statement.
15. B. Option A is incorrect because USING is incorrect syntax. Option C is incorrect
because you do not explicitly use PDB$SEED as the source for a clone.
16. A, B, D. Option C is the only incorrect answer; it is not a valid package.