Oracle Exam 1Z0-062 Topic 4 Question 45 Discussion

Actual exam question for Oracle's 1Z0-062 exam

Question #: 45
Topic #: 4

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.)

AThe expdp operation exports data that satisfies the condition of the defining query used to create the EMP_DEPT view.

BThe impdp operation creates the view and dependent objects.

CAll rows from the dependent objects, along with the metadata required to create the EMP_DEPT view, are exported.

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 export dump file.

Show Suggested Answer

Suggested Answer: A, D, E

by Daron at May 08, 2022, 04:52 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!