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

16. B, D. Option A is incorrect because the entire CDB and all of its PDBs are in the same
role, either primary or standby. Option C is incorrect because each PDB will follow
the role of its CDB, so individual fail over or switchover is not necessary.
17. C. Answer A is not correct because Data Guard does not automatically create the PDB
in the standby databases. Answer B is incorrect because you do not have to clone the
PDB to the standby CDBs.
18. A. Option B and D are not correct initialization parameter names. Answer C is correct
when creating a new PDB in a CDB, but not in this scenario.
19. E. Options A, B, C, and D are valid use cases for LogMiner.
20. A, D. Answers B and C are not correct because a LogMiner dictionary is not required,
but it makes mining more convenient.
Chapter 14: Oracle Security in
CDBs and PDBs
1. B. A common user has the same identity in all containers in a CDB and has the capabil-
ity to access all containers. Only Oracle-supplied common users in a CDB would appear
similar to Oracle-supplied users in a non-CDB; however, non-CDBs do not have common
or local users. Common users can create common users, so D is incorrect.
2. C, D. Answers A and B are true; answers C and D are not true. A common user is identi-
fied by the same password in all containers. A local user is uniquely defined in each PDB.
3. E. Option A is incorrect because usernames and role names cannot be the same.
Answer B is incorrect because common users are identified by the same password in all
containers. Answer C is incorrect because you cannot create a local user in CDB$ROOT .
Answer D is incorrect because you must create a common user in CDB$ROOT .
4. D. Answer A is incorrect because local users must be unique in a PDB, but they may
be independently non-unique across PDBs within the same CDB. Answer B is incorrect
because local users are defined locally. Answer C is incorrect because you must be a
common user with DBA, SYSOPER, or SYSDBA privileges to shut down a CDB.
5. C. Answer A is incorrect because ALL is not required; it is implied. Answer B is incorrect
because CURRENT is implied when creating a local user, not a common user. Answer D is
an invalid value option.
6. B. Answer A is incorrect because local users have access only to the PDB they are
created in. Answer C is incorrect because local users in one PDB are independent from
local users in other PDBs. Answer D is incorrect because local users are not used in
the CDB$ROOT .