Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?（）A、The import operation must be performed by a user on the target data

题目

Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?（）

  • A、The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.
  • B、All the user-defined tablespaces must be in read-only mode on the source database.
  • C、The export dump file must be created before starting the import on the target database.
  • D、The source and target database must be running on the same platform with the same endianness.
  • E、The path of data files on the target database must be the same as that on the source database.
  • F、The impdp operation must be performed by the same user that performed the expdp operation.
相似考题

1.Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?()A. Both source and target database must be the same character setB. Both source and target database must have the same endian formatC. The COMPATIBLE parameter must be the same in the source and target databases.D. The minimum compatibility level for both the source and target database must be 10.0.0.E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

2.Examine the following command:SQL> ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?()A. The shrink operation touches every block in the BOOKING tableB. The high-water mark (HWM) for the BOOKING table is shifted from its original positionC. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD. The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

3.You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?（）A. The source database should be openB. The target database should be in ARCHIVELOG mode if it is openC. RMAN should be connected to both the instances as SYSDBAD. The target database backups should be copied to the source database backup directoriesE. The password file must exist for the source database and have the same SYS user password as the target

4.Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? ()A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

更多“Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?（）A、The import operation must be performed by a user on the target data”相关问题

  • 第1题：

    Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?() (Choose three.)

    A. Both source and target database must be the same character set

    B. Both source and target database must have the same endian format

    C. The COMPATIBLE parameter must be the same in the source and target databases.

    D. The minimum compatibility level for both the source and target database must be 10.0.0.

    E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.


    参考答案：A, B, D

  • 第2题：

    Which three statements are true about Oracle Data Pump export and import operations?()

    A. You can detach from a data pump export job and reattach later.

    B. Data pump uses parallel execution server processes to implement parallel import.

    C. Data pump import requires the import file to be in a directory owned by the oracle owner.

    D. The master table is the last object to be exported by the data pump.

    E. You can detach from a data pump import job and reattach later.


    参考答案：A, B, D

  • 第3题：

    In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）

    • A、a tablespace is taken offline
    • B、the database instance is restarted
    • C、a new data file is added to an existing tablespace
    • D、a successful backup is recorded in the RMAN repository
    • E、the RMAN connection is disconnected from the target database

    正确答案:C,D

  • 第4题：

    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

    正确答案:C

  • 第5题：

    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） 

    • A、back up the control file to trace
    • B、bring database to the MOUNT state
    • C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
    • D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

    正确答案:C

  • 第6题：

    Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）

    • A、Both source and target database must be the same character set
    • B、Both source and target database must have the same endian format
    • C、The COMPATIBLE parameter must be the same in the source and target databases.
    • D、The minimum compatibility level for both the source and target database must be 10.0.0.
    • E、All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

    正确答案:A,B,D

  • 第7题：

    Which three statements are true about Oracle Data Pump export and import operations?（）

    • A、You can detach from a data pump export job and reattach later.
    • B、Data pump uses parallel execution server processes to implement parallel import.
    • C、Data pump import requires the import file to be in a directory owned by the oracle owner.
    • D、The master table is the last object to be exported by the data pump.
    • E、You can detach from a data pump import job and reattach later.

    正确答案:A,B,D

  • 第8题：

    Examine the following command：   SQL> ALTER TABLE booking SHRINK SPACE COMPACT；   Which activity is performed when the preceding command is executed？（）

    • A、 The shrink operation touches every block in the BOOKING table
    • B、 The high-water mark （HWM） for the BOOKING table is shifted from its original position
    • C、 The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
    • D、 The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

    正确答案:C

  • 第9题：

    You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）

    • A、the CONVERT command of RMAN
    • B、Data Pump Export and Import into the same database
    • C、conventional export and import into the same database
    • D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
    • E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

    正确答案:A,E

  • 第10题：

    You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）

    • A、the CONVERT command of RMAN
    • B、Data Pump Export and Import into the same database
    • C、conventional export and import into the same database
    • D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
    • E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

    正确答案:A,E

  • 第11题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


    正确答案： C
    解析： 暂无解析

  • 第12题：

    多选题
    You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）
    A

    SYSDATE should not be used with TIMESTAMP.

    B

    The database must have multiplexed redo log files.

    C

    The database must be in the MOUNT state to execute the command.

    D

    The database must be opened with the RESETLOGS option after the flashback operation.

    E

    The entire database needs to be restored from the most recent backup before the flashback operation.


    正确答案： E,B
    解析： 暂无解析

  • 第13题：

    Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）

    A. It contains data till the last backup

    B. It contains all data from target database until the current time

    C. It contains all data from only the committed transactions in the target database

    D. It contains all data except that which is used by the transactions in the current online redo file of target database


    参考答案：D

  • 第14题：

    Examine the following impdp command to import a database over the network from a pre－12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?()

    A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.

    B. All the user-defined tablespaces must be in read-only mode on the source database.

    C. The export dump file must be created before starting the import on the target database.

    D. The source and target database must be running on the same platform with the same endianness.

    E. The path of data files on the target database must be the same as that on the source database.

    F. The impdp operation must be performed by the same user that performed the expdp operation.


    参考答案：B, C, E

  • 第15题：

    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data

    正确答案:C

  • 第16题：

    You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

    • A、SYSDATE should not be used with TIMESTAMP.
    • B、The database must have multiplexed redo log files.
    • C、The database must be in the MOUNT state to execute the command.
    • D、The database must be opened with the RESETLOGS option after the flashback operation.
    • E、The entire database needs to be restored from the most recent backup before the flashback operation.

    正确答案:C,D

  • 第17题：

    Which of the following roles must be granted to a user to perform a full database import？（）

    • A、CONNECT
    • B、IMP_FULL_DATABASE
    • C、FULL_EXPORT_PRIVS
    • D、RESOURCE
    • E、FULL_IMPORT_PRIVS

    正确答案:B

  • 第18题：

    Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）

    • A、All database operations performed by the impdp command are logged.
    • B、Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
    • C、Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
    • D、None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

    正确答案:A

  • 第19题：

    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data.

    正确答案:C

  • 第20题：

    Examine the following scenario： The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host， using the Recovery Manager （RMAN） duplicate command as follows：   RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK；  DUPLICATE TARGET DATABASE TO auxdb； }   Which statement is true about the duplicate database in this scenario？（）  

    • A、 It contains data till the last backup
    • B、 It contains all data from target database until the current time
    • C、 It contains all data from only the committed transactions in the target database
    • D、 It contains all data except that which is used by the transactions in the current online redo file of target database

    正确答案:D

  • 第21题：

    Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（） (Choose three.)

    • A、Both source and target database must be the same character set
    • B、Both source and target database must have the same endian format
    • C、The COMPATIBLE parameter must be the same in the source and target databases.
    • D、The minimum compatibility level for both the source and target database must be 10.0.0.
    • E、All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

    正确答案:A,B,D

  • 第22题：

    单选题
    Which of the following roles must be granted to a user to perform a full database import？（）
    A

    CONNECT

    B

    IMP_FULL_DATABASE

    C

    FULL_EXPORT_PRIVS

    D

    RESOURCE

    E

    FULL_IMPORT_PRIVS


    正确答案： E
    解析： 暂无解析

  • 第23题：

    多选题
    Which three statements are true about Oracle Data Pump export and import operations?（）
    A

    You can detach from a data pump export job and reattach later.

    B

    Data pump uses parallel execution server processes to implement parallel import.

    C

    Data pump import requires the import file to be in a directory owned by the oracle owner.

    D

    The master table is the last object to be exported by the data pump.

    E

    You can detach from a data pump import job and reattach later.


    正确答案： A,D
    解析： 暂无解析

  • 第24题：

    单选题
    Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）
    A

    All database operations performed by the impdp command are logged.

    B

    Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.

    C

    Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.

    D

    None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.


    正确答案： A
    解析： 暂无解析

相关内容