Exam 1z0-063 topic 1 question 46 discussion

Actual exam question from Oracle's 1z0-063

Question #: 46
Topic #: 1

Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?

A. expdp will fail because no path has been defined for the dumpfile.
B. expdp will succeed but impdp will fail because the users do not exist.
C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.
D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

Show Suggested Answer

Suggested Answer: B 🗳️

by rcgenilo27 at July 16, 2020, 5:40 a.m.

Comments

Submit Cancel

Arin_DBA

2 years ago

D is Answer .....Link https://db.geeksinsight.com/2013/01/03/impdp-remap_schema-creates-new-schema/

upvoted 1 times

...

Simon22

3 years, 8 months ago

D is correct. why would impdp fail ? No reason.

upvoted 3 times

...

sergezaza83

4 years, 2 months ago

Bis correct

upvoted 2 times

...

rcgenilo27

4 years, 6 months ago

ans: D

upvoted 2 times

Sugar

4 years, 6 months ago

B is correct.

upvoted 3 times

...

badguy001djh

3 years, 9 months ago

In impdp command,value of parameter schemas is 'hr1,oe1', which is not exists in source database. So B is correct.

upvoted 2 times

...

Exam 1z0-063 All Questions

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

Exam 1z0-063 topic 1 question 46 discussion

Comments

Arin_DBA

Simon22

sergezaza83

rcgenilo27

Sugar

badguy001djh

SY0-701