Oracle Database 12c: Installation and Administration — Question 108
You ran this command on a source database:
On the target database, you run this command:
gt; impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept
Which two statements are true? (Choose two.)
Answer options
- 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
Correct answer: C, D
Explanation
The correct answer C indicates that the expdp operation exports all rows visible in the EMP_DEPT view without any filters. Option D is also correct as the impdp operation creates EMP_DEPT as a table based on the view. The other options are not correct because they either misrepresent what expdp does in terms of exporting or incorrectly describe the behavior of impdp.