Oracle
1Z0-034 · Question #100
1Z0-034 Question #100: Real Exam Question with Answer & Explanation
The correct answer is B. expdp will succeed but Impdp will fail because users do not exist.. See the full explanation below for the reasoning.
Question
Examine these Data Pump commands to import objects to non-existent users hr1 and oe1. S expdp system/manager Schemas =hr,oe directory =EXP_ DIR include = table $ impdp system/manager Schemas = hr1,oe1 Directory = EXP_DIR Dumpfile = export.dat Remap_schema =hr:hr1,oe :oe1 What would be achieved by running the above commands?
Options
- Aexpdp will fail because no path has been defined for the dumpfile.
- Bexpdp will succeed but Impdp will fail because users do not exist.
- Cimpdp will create two users called hrl and oe1 and import all objects to the new schemas
- Dimpdp will create two users called hrl and oe1 and import tables owned by hr and oe schemas to
Community Discussion
No community discussion yet for this question.