Database Reference
In-Depth Information
17.
C. Answers A, B, D, and E are necessary steps to migrate a non-CDB to a PDB.
18.
C, D. Option A is incorrect because the requirement is to shut down the non-CDB
prior to creating the XML file and copying the datafiles; this is not executed on the
target CDB. Option B is not correct, because the PDB needs to be in read/write mode.
19.
A, B, C. Option D is incorrect, because the PDB must be closed, not open in read-only
mode, before you can unplug it.
20.
C. Option C is correct, since none of the other proposed answers are requirements to
drop a PDB. The PDB must be closed before you can drop it.
Chapter 12: Managing Oracle
Multitenant Databases
1.
C. Common users have access to all PDBs and the root container of the CDB. A com-
mon user defined in the current CDB does not have access to all CDBs, so option A is
not correct.
2.
D. The local user by definition has access to only one PDB.
3.
C. Option A incorrectly uses the
COMMON
keyword and Option B incorrectly uses the
CDB$ROOT
container name.
4.
E. Answer A is incorrect because a common user can create local users. Answer B is
incorrect because a local user can create a local user, as long as the creating user has
sufficient privileges. Answer C is incorrect because each PDB has its own set of local
users. Answer D is incorrect because you do not have to be a DBA to create users.
5.
E.
SHOW CON_NAME
is the correct SQL*Plus command.
6.
B. At the OS prompt, enter
lsnrctl stat
and the list of currently available services
will be displayed.
7.
E. Option A is incorrect because
FORCE
should not be used under normal circumstances.
Option B is incorrect because under normal circumstances you would
OPEN
the CDB.
Options C and D are incorrect because the CDB must be started from the root. Under
normal circumstances, you would issue
STARTUP
from
CDB$ROOT
.
8.
E.
SHUTDOWN ABORT
is used only when no other option will work.
SHUTDOWN
TRANSACTIONAL
will wait for all pending transactions to complete.
Search WWH ::
Custom Search