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

3. A, D. Option B is incorrect because using the SYS user to import the contents will not
remap or create a new local account. Answer C is incorrect because the mapping would
then be the opposite of what you want.
4. A. Answer B is incorrect because the PDB doesn't know about the DUMPFILE directory of
the CDB. You must define the DUMPFILE directory at the PDB using the CREATE DIRECTORY
statement in SQL*Plus.
5. C, D. Answer A is incorrect because Data Pump does not allow any CDB-wide operations
( CDB$ROOT ). For the same reason B is incorrect; Oracle Data Pump doesn't allow import
operations on PDB$SEED .
6. D. Answer A is incorrect because you do not use SQL*Loader to connect two tables
in two distinct Oracle databases. Answer B is incorrect because you do not use a
binary source file. Answer C is incorrect because you do not use SQL*Loader to load
CDB$ROOT tables.
7. C. Option A is incorrect because the data file contains the source data records and the
control file describes the layout of the data to be imported. Option B is incorrect because
the parfile is optional. Option D is incorrect because the WHEN clause is not required.
8. A, D. Answer B is incorrect because SQL*Loader assumes the stream record format is
to be used if you do not specify variable or fixed-length records. Answer C is incorrect
because fixed record format performs the best, all other things being equal.
9. E. Answer A is incorrect because the conventional path load uses SQL INSERT state-
ments. Answer B is incorrect because DIRECT=TRUE directs SQL*Loader to use the direct
path load. Answer C is incorrect because truncating is not required prior to a direct path
load. Answer D is incorrect because the direct path load copies data from the data file
directly into data blocks above the high-water mark in the target database table.
10. E. None of these are required to run SQL*Loader in express mode. The only requirement
on the command line is the target table name, which is also the name of the data file.
11. D. Answer A is incorrect because auditing policies can be common or local. Answers B
and C are incorrect because common auditing policies apply only to common objects.
12. A. Answer A is true, but you must also indicate EXPORT , IMPORT , or ALL . There is no
default value, and UNIFIED is not an option.
13. C. Option A is incorrect because conventional path loads are not audited. Only direct
path loads can be audited, but you must create an audit policy and enabling auditing first.
14. D. Option A describes Oracle Secure Backup. Answer B is not correct. Answer C
describes Oracle Data Guard.
15. A, B, D. Option C is not a valid role.