nerdexam
Oracle

1Z0-062 · Question #351

Examine the command to perform a data pump export operation on a source database: $> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept On the target database, you execute the…

The correct answer is A. The expdp operation exports data that satisfies the condition of the defining query used to D. Objects dependent on the EMP_DEPT view are exported. E. The impdp operation creates EMP_DEPT as table and populates it with the data from the. Using VIEWS_AS_TABLE in Data Pump exports a view's data as a table, including its dependent objects, and during import, it creates a new table on the target database, populated with the view's data.

Moving Data

Question

Examine the command to perform a data pump export operation on a source database:

$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept On the target database, you execute the data pump import command:

$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept Which three statements are true? (Choose three.)

Options

  • AThe expdp operation exports data that satisfies the condition of the defining query used to
  • BThe impdp operation creates the view and dependent objects.
  • CAll rows from the dependent objects, along with the metadata required to create the
  • DObjects dependent on the EMP_DEPT view are exported.
  • EThe impdp operation creates EMP_DEPT as table and populates it with the data from the

How the community answered

(37 responses)
  • A
    78% (29)
  • B
    14% (5)
  • C
    8% (3)

Why each option

Using `VIEWS_AS_TABLE` in Data Pump exports a view's data as a table, including its dependent objects, and during import, it creates a new table on the target database, populated with the view's data.

AThe expdp operation exports data that satisfies the condition of the defining query used toCorrect

When `VIEWS_AS_TABLE=emp_dept` is specified, the `expdp` operation executes the defining query of the `EMP_DEPT` view and exports the result set as data, as if it were a table.

BThe impdp operation creates the view and dependent objects.

The `VIEWS_AS_TABLE` option converts the view into a table during the import process, meaning it creates a table, not the original view or its original dependent view objects.

CAll rows from the dependent objects, along with the metadata required to create the

The export exports the data derived from the view's query and the metadata needed to create a table from that view, not necessarily 'all rows from the dependent objects' in a broad sense, but rather the dependencies necessary for the view's definition.

DObjects dependent on the EMP_DEPT view are exported.Correct

The `VIEWS_AS_TABLE` parameter not only exports the data from the specified view as a table but also includes any underlying objects on which that view itself directly depends.

EThe impdp operation creates EMP_DEPT as table and populates it with the data from theCorrect

During the `impdp` operation with `VIEWS_AS_TABLE=emp_dept`, Data Pump creates a new physical table named `EMP_DEPT` on the target database and populates it with the data that was extracted from the view during the export.

Concept tested: Oracle Data Pump VIEWS_AS_TABLE option

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/data-pump-export-utility.html#GUID-E138E662-7935-4309-8C2C-22340356C19F

Topics

#Oracle Data Pump#VIEWS_AS_TABLE#data export#data import

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice