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.
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)- A78% (29)
- B14% (5)
- C8% (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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.