Exam 1z0-052 topic 2 question 28 discussion

Actual exam question from Oracle's 1z0-052

Question #: 28
Topic #: 2

database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server:

The command fails displaying the following error:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable to obtain file status
What would you do to overcome the error?

A. Add the user, SYSTEM, to the schemas option.
B. Add the network_link = devdb.us.oracle.com option.
C. Change the dumpfile option to [email protected].
D. Replace the schemas option with the network_link = devdb.us.oracle.com
E. Replace the dumpfile option with the network_link = devdb.us.oracle.com

Show Suggested Answer

Suggested Answer: E 🗳️
The Data Pump import command, impdp, can now use this database link to directly access remote data. The command line parameter NETWORK_LINK points to the source database via its database link.
When you use the network_link parameter, you directly import from the remote database. There is no export made, and directories are not used.

by thuthuysphn58 at April 4, 2025, 7:22 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!

Exam 1z0-052 All Questions

View all questions & answers for the 1z0-052 exam

Exam 1z0-052 topic 2 question 28 discussion

Comments

SY0-701