Exam 1z0-062 topic 2 question 9 discussion

Actual exam question from Oracle's 1z0-062

Question #: 9
Topic #: 2

You ran this command on a source database:
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept
On the target database, you run this command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept
Which two statements are true? (Choose two.)

A. The expdp operation exports all rows for tables contained in the defining query of the EMP_DEPT view
B. The impdp operation creates separate tables for each table contained in the defining query of the EMP_DEPT view
C. The expdp operation exports all rows that are displayed when querying the EMP_DEPT view with no filter
D. The impdp operation creates EMP_DEPT as a table
E. The expdp operation exports the table definitions for tables that are queried in the EMP_DEPT view.
F. The impdp operation creates EMP_DEPT as a view

Show Suggested Answer

Suggested Answer: CD 🗳️

by kingdeerman at April 12, 2020, 5:26 p.m.

Comments

Submit Cancel

kingdeerman

Highly Voted 5 years, 1 month ago

CD is correct

upvoted 15 times

...

migreab_04

Most Recent 2 years, 11 months ago

Selected Answer: DE

D E Go to the question #325

upvoted 1 times

...

dfabac

2 years, 12 months ago

Selected Answer: CD

Answer is CD

upvoted 1 times

...

NorwayOracle

3 years, 1 month ago

Selected Answer: CD

c: Views_as_table: 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. d) Views_as_table: Specifies that one or more tables in the dump file that were exported as views, should be imported.

upvoted 2 times

...

AntoineCOMOE

4 years, 12 months ago

AD is correct

upvoted 1 times

AntoineCOMOE

4 years, 11 months ago

CD is correct

upvoted 6 times

...