Exam 1z0-062 topic 1 question 325 discussion

Actual exam question from Oracle's 1z0-062

Question #: 325
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: ADE 🗳️

by jackymak at April 3, 2022, 3:34 a.m.

Comments

Submit Cancel

Ray520

3 years, 1 month ago

Selected Answer: ADE

Exports view emp_dept as a table with same data and columns as in the view. The dump file will contain a table with the name emp_dept holding data from the view. Data Pump also exports objects dependent on the view, such as grants and constraints.

upvoted 2 times

...

Paps23

3 years, 2 months ago

agree with CDE

upvoted 1 times

...

NorwayOracle

3 years, 2 months ago

Selected Answer: ADE

Data Pump exports a table with the same columns as the view and with row data fetched from the view. 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.The VIEWS_AS_TABLES parameter can be used by itself or along with the TABLES parameter. If either is used, Data Pump performs a table-mode export.

upvoted 3 times

...

jackymak

3 years, 3 months ago

Selected Answer: CDE

I think C D E. https://docs.oracle.com/database/121/SUTIL/GUID-E4E45E81-5391-43BE-B27D-B763EF79A885.htm#SUTIL3904

upvoted 2 times

jackymak

3 years, 2 months ago

Sorry, ADE is correct

upvoted 2 times

...