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.
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.
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
Why A is correct then “to create the EMP_DEPT view. “
ADE
This question appears on my real Test PeasonVue on Oct 6 2017.