Oracle Database 12c: Advanced Administration — Question 143

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because the export operation (expdp) will successfully run as it does not require the target schemas to exist, but the import operation (impdp) will fail since the specified users hr1 and oe1 have not been created. The other options are incorrect as they misrepresent the behavior of the Data Pump commands regarding user creation and the necessity of existing schemas for import operations.