Which three statements are true?

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)

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)

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.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Christine

Christine

These are new exam questions since Oracle changed their syllabus after April 15, 2017. These are 41 questions and they all came into my exam but my answers were wrong that’s why I failed :(. Guys, please help here to get the correct answers.

Hvd

Hvd

ADE

B. impdp will create the EMP_DEPT as table, not view

D. Data Pump also exports objects dependent on the view, such as grants and constraints. Dependent objects that do not apply to tables (for example, grants of the UNDER object privilege) are not exported

Cihan Gedik

Cihan Gedik

Why A is correct then “to create the EMP_DEPT view. “

Công Tử Bột

Công Tử Bột

This question appears on my real Test PeasonVue on Oct 6 2017.