Database Reference
In-Depth Information
Review Questions
1. In the Oracle 12 c multitenant architecture, which of these are characteristics of a
common user? (Choose all that apply.)
A. Appears the same in a non-CDB or a CDB
B. Appears the same in all PDBs in a CDB
C. Can access only the CDB$ROOT
D. Is Oracle-supplied only
E. All of the above
2. Which of the following are not true about common and local users in a CDB?
(Choose all that apply.)
A. A common user is a database user who has the same username and password in
the root and in every PDB in the CDB.
B. A local user is defined in a PDB and does not have access to the CDB$ROOT or other
PDBs, very much like a user in a non-CDB.
C. A common user is a database user who has the same username in the root and in
every PDB in the CDB, but their password may be different in each container.
D. A local user is defined in every PDB and does not have access to the CDB$ROOT , very
much like a user in a non-CDB.
3. Which of the following is true regarding a common user?
A. A common user may have the same name as a common role, as long as they're not
defined in the same container.
B. Common users can change their passwords to be unique in each PDB.
C. A common user can create a local user in the CDB$ROOT .
D. A local user may create a common user in a PDB.
E. None of the above
4. A local user account must comply with which of the following restrictions?
A. All local users must be unique in a CDB.
B. You must define local users from the CDB$ROOT as common users.
C. A locally created user with the DBA role can shut down a CDB.
D. None of the above
Search WWH ::




Custom Search