You have created a database link， devdb.us.oracle.com， between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database， DEVDB， to the production database， PRODDB. You execute the following command on the target database server： 
$impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr 
flashback_time = 2004-02-03 09：00 
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（）

单项选择题You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.  Which option of IMPDP would you use to accomplish this task（）

A.FULL
B.SCHEMAS
C.TRANSFORM
D.REMAP_SCHEMA
E.REMAP_TABLESPACE

多项选择题InwhichsituationsdoestheOracleDataPumpuseexternaltablesandnotthedirectpathloadwhileexportingatable（）

A.if a table is not in a cluster
B.if a table has an active trigger
C.if a table has an encrypted
D.if a table has a column of data type LONG defined on it
E.if a table has a referential integrity constraint defined on it

多项选择题WhichtwostatementsaretrueregardingOracleDataPump（）

A.EXPDP and IMPDP are the client components of Oracle Data Pump.
B.DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C.Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D.Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
E.EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

多项选择题WhichtwostatementsaretrueregardingtheusageoftheSQL*Loaderutility（）

A.You can load data into multiple tables during the same load session.
B.You can load data from multiple files to a table during the same load session.
C.You cannot perform selective data loading based on the values available in the records.
D.You can use an export file generated by the EXPDP utility as an input data file to load the data.
E.You can load data only if the input file is available on the disk and tape but not in a named pipes.

单项选择题WhichstatementistrueaboutloadingdatausingtheconventionalpathofSQL*Loader（）

A.Redo is not generated while performing conventional path loads.
B.Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.
C.No exclusive locks are acquired when the conventional path loads are performed.
D.Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.
E.INSERT triggers are disabled before the conventional path load and reenabled at the end of the load.