Examine the following query output: You issue the following command to import tables into
the hr schema: Which statement is true?
A.
All database operations performed by the impdp command are logged.
B.
Only CREATE INDEX and CREATE TABLE statements generated by the import are
logged.
C.
Only CREATE TABLE and ALTER TABLE statements generated by the import are
logged.
D.
None of the operations against the master table used by Oracle Data Pump to coordinate
its activities are logged.
C is correct
The new TRANSFORM parameter (a parameter you can specify during an import)
option DISABLE_ARCHIVE_LOGGING (which you can specify during an impdp command) will
result in the disabling of redo logging when loading data into a table and when creating an
index. The ability to disable logging during imports is especially useful when populating a new
database.
Certain Oracle Data Pump DDL and DCL operations, such as all
the CREATE and ALTER statements (except CREATE INDEX) and all operations against the
master table used by Oracle Data Pump, are still logged.