Oracle Utilities - OCP: Oracle Database 12c Administrator Certified Professional - page 620

9. Which of the following describes a SQL*Loader direct path load?
A. By default all records are written to the database using SQL INSERT statements,
committed in bulk, and optimized for data loads.
B. Using the control file parameter SQLLOAD=DIRECT , the data file is converted into a
binary database file and directly attached to the PDB.
C. You must truncate the contents of the target table before using the direct load
method.
D. Using the control file parameter DIRECT=TRUE , SQL*Loader will utilize the data file
as an external table and load it into memory to provide direct access for the user's
SQL statements, thus greatly improving performance.
E. None of the above.
10. When using SQL*Loader in express mode, you need to specify which of the following?
A. A control file
B. A parameter file
C. A variable-length data file
D. The name of the source data file
E. None of the above
11. Which of these is true regarding audit operations?
A. Auditing rules always apply to the entire CDB.
B. Common auditing policies override local auditing policies.
C. Common audit policies apply to all objects in all PDBs and the CDB.
D. Audit policies are by default local to the current PDB.
E. None of the above.
12. Which of the following is true regarding audit policies and Data Pump jobs?
A. You must specify COMPONENT=DATAPUMP when creating the audit policy.
B. You must specify EXPORT and IMPORT separately when creating audit policies.
C. By default the audit policy applies to both EXPORT and IMPORT .
D. The unified audit trail is used only when you specify COMPONENT=DATAPUMP UNIFIED .
E. None of the above.
13. Regarding auditing SQL*Loader, which of the following is true?
A. By default all SQL*Loader conventional path loads are audited.
B. By default all SQL*Loader direct path loads are audited.
C. Only direct path loads can be audited.
D. None of the above.