ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 325 discussion

Actual exam question from Oracle's 1z0-062
Question #: 325
Topic #: 1
[All 1z0-062 Questions]

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 Hide Answer
Suggested Answer: ADE 🗳️
by jackymak at April 3, 2022, 3:34 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Ray520
2 years, 11 months 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 ago
agree with CDE
upvoted 1 times
...
NorwayOracle
3 years 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 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
2 years, 12 months ago
Sorry, ADE is correct
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago