Oracle Database 12c: Installation and Administration — Question 207
Examine the command to perform a data pump export operation on a source database:
On the target database, you execute the data pump import command:
gt; impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept
Which three statements are true? (Choose three.)
Answer options
- A. The expdp operation exports data that satisfies the condition of the defining query used to create the EMP_DEPT view.
- B. The impdp operation creates the view and dependent objects.
- C. All rows from the dependent objects, along with the metadata required to create the EMP_DEPT view, are exported.
- 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 export dump file.
Correct answer: A, D, E
Explanation
Statement A is correct because the expdp command exports data that meets the criteria of the EMP_DEPT view's defining query. Statement D is also true, as it indicates that dependent objects are included in the export. Statement E is correct since the impdp command creates the EMP_DEPT view as a table and populates it with the exported data. Statements B and C are incorrect because the impdp command does not create the view and dependent objects, nor does it export all rows from dependent objects.