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

9. E. All DBA-created PDBs are in MOUNTED status when the CDB is opened and the
PDB$SEED container is in READ ONLY status.
10. E. None of these are required to open a PDB. The Oracle_SID doesn't have to be set to
the PDB service name; the PDB doesn't have to be the current container, nor does the
CDB$ROOT . A local user with SYSDBA or similar privileges may open the PDB.
11. B. Each of the other commands uses incorrect syntax.
12. A. It is not necessary for the user closing the PDB to be a local user, nor does it matter
if the current container is the PDB.
13. A, C. Option B is incorrect because you should not abort a PDB in normal circumstances.
Option D is incorrect because CLOSE PLUGGABLE DATABASE is not a valid command.
14. A. Option A is the only correct combination. STARTUP FORCE shuts down the CDB or PDB
as would a SHUTDOWN ABORT ; then it starts the database and opens it for general access.
15. D. Option A is incorrect because transactions are allowed to complete. Option B is
incorrect because no new transactions are allowed. Option C is incorrect because
transactions are allowed to complete before the sessions are terminated.
16. B, C, D. Option A is incorrect because CDB$ROOT is not always the current container.
Option D is correct because a common user can create multiple sessions in different con-
tainers; for each session the current container may be any one of the PDBs or CDB$ROOT
where the common user has privileges to connect.
17. C. Answer A is not necessary at CDB creation. It can be used at PDB creation when
cloning a PDB from some source other than PDB$SEED . Answer B is not a valid param-
eter. Answer D is incorrect because it is not necessary when creating a CDB.
18. C. Option C is the only correct initialization parameter name.
19. E. Options A, B, and C are invalid. Answer D, PROCESSES , is used to calculate SESSIONS
if SESSIONS is not explicitly set.
20. A, B, C, D. Each option is a valid step in the process to increase the MAX_STRING_SIZE
for a PDB.
Chapter 13: Oracle Utilities
1. E. Each of the answers represents a valid and common use for Data Pump in the
multitenant environment.
2. D. Answer A is incorrect because expdp is associated with export, not import. Answer B
is incorrect because that responsibility lies with DBMS_METADATA. Answer C is
incorrect because direct path load is not a function of Data Pump.