多项选择题

Which two statements are true regarding the Oracle Data Pump export and import operations（）

A.You cannot export data from a remote database.
B.You can rename tables during an import operation.
C.You can overwrite existing dump files during an export operation.
D.You can compress the data during export but not the metadata because it is not supported.

点击查看答案

上一题目录下一题

相关考题

单项选择题

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（）

A.remove the dumpfile option in the command
B.remove the flashback_time option in the command
C.remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command（Replace thedumpfile option with the network_link = devdb.us.oracle.com）
D.add the user， SYSTEM， to the schemas option in the command
E.remove the schemas option and add the network_link = devdb.us.oracle.com option in the command
F.add network_link = devdb.us.oracle.com option in the command

单项选择题

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

多项选择题

In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）

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