Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr…

The correct answer is C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged. Oracle Data Pump disable redo logging when loading data into tables and when creating indexes. The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo generation for the objects during the course of import. The Master Table is used…

New Features for Manageability

Question

Examine the following query output:

You issue the following command to import tables into the hr schema:

$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?

Exhibit

Options

AAll database operations performed by the impdp command are logged.
BOnly CREATE INDEX and CREATE TABLE statements generated by the import are logged.
COnly CREATE TABLE and ALTER TABLE statements generated by the import are logged.
DNone of the operations against the master table used by Oracle Data Pump to coordinate its activities

How the community answered

(55 responses)

A
13% (7)
B
4% (2)
C
78% (43)
D
5% (3)

Explanation

Oracle Data Pump disable redo logging when loading data into tables and when creating indexes. The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo generation for the objects during the course of import. The Master Table is used to track the detailed progress information of a Data Pump job. The Master Table is created in the schema of the current user running the Pump Dump export or import, and it keeps tracks of lots of detailed information.

Topics

#Data Pump import#DISABLE_ARCHIVE_LOGGING#impdp#logging

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice