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