当前位置:1Z0-052题库

问题:

[单选]

You want to import schema objects of the HR user using Oracle Data Pump from the development database,DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server:$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr
flashback_time = "TO_TIMESTAMP(’25-08-2007 14:35:00’, ’DD-MM-YYYY HH24:MI:SS’)"The command fails displaying the following error:ORA-39001: invalid argument valueORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable toobtain file status
What would you do to overcome the error()

A . Add the user, SYSTEM, to the schemas option.
B . Add the network_link = devdb.us.oracle.com option.
C . Change the dumpfile option to schema.dat@devdb.us.oracle.com.
D . Replace the schemas option with the network_link = devdb.us.oracle.com
E . Replace the dumpfile option with the network_link = devdb.us.oracle.com

中国城市化的基本特征。 旁站是监理人员在现场对关键部位或关键工序施工进行的()活动。 A.全过程监督 。 B.监督 。 C.现场监督 。 D.巡视。 You are using an Automatic Storage Management (ASM) instance to manage the database files of your production database. After adding a new disk group to the ASM instance, you execute the following command:  ALTER DISKGROUP dg3 REBALANCE POWER 0; What would be the result of this command?() The rebalancing of the disk group would be stopped.。 The rebalancing of the disk group would be completed as fast as possible.。 The command would result in an error because the value of POWER cannot be 0.。 The rebalancing of the disk group would be completed without affecting the disk group DG3.。 The command would result in an error because the disk groups cannot be manually rebalanced.。 In which two cases would you use an outer join? () The tables being joined have NOT NULL columns.。 The tables being joined have only matched data.。 The columns being joined have NULL values.。 The tables being joined have only unmatched data.。 The tables being joined have both matched and unmatched data.。 Only when the tables have a primary key/foreign key relationship.。 To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code: The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?() A template needs to be associated with the task.。 A workload needs to be associated with the task.。 The partial or complete workload scope needs to be associated with the task.。 The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.。

You want to import schema objects of the HR user using Oracle Data Pump from the development database,DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server:$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr
flashback_time = "TO_TIMESTAMP(’25-08-2007 14:35:00’, ’DD-MM-YYYY HH24:MI:SS’)"The command fails displaying the following error:ORA-39001: invalid argument valueORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable toobtain file status
What would you do to overcome the error()

参考答案:

  参考解析

本题暂无解析

在线 客服