多选题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?（）AThe import operation must be performed by a user on the target da

题目
多选题
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.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 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.

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

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

更多“多选题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?（）AThe import operation must be performed by a user on the target da”相关问题

  • 第1题：

    How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）  

    • A、 Issue the grant command from the SYS user （or equivalent） of the target database.
    • B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.
    • C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
    • D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
    • E、 Issue the grant command from RMAN when connected to the target database.

    正确答案:D

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    多选题
    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）
    A

    The database must have multiplexed redo log files

    B

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

    C

    The database must be in the NOMOUNT state to execute the command

    D

    The database must be opened in RESTRICTED mode before this operation

    E

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


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

  • 第6题：

    多选题
    You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）
    A

    The source database backup must be copied over the net for test database.

    B

    The source database must be run in ARCHIVELOG mode if the database is open.

    C

    The source database must be shut down cleanly if the database is in mounted state.

    D

    A net service name should be set up and a listener configured with the target as well as the source database.


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

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    多选题
    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


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

  • 第9题：

    多选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    Examine this statement：  RMAN >BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2；  What state must the target database be in for you to use this RMAN command？（）
    A

    The target database must be open.

    B

    The target database must be closed.

    C

    The target database must be mounted.

    D

    The target database must be mounted or open.


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

  • 第11题：

    单选题
    How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）
    A

     Issue the grant command from the SYS user （or equivalent） of the target database.

    B

     Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.

    C

     Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.

    D

     Issue the grant command from RMAN when connected to the recovery catalog-owning schema.

    E

     Issue the grant command from RMAN when connected to the target database.


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

  • 第12题：

    多选题
    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.


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

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


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

  • 第18题：

    多选题
    Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（）
    A

    The command restores only the missing control file.

    B

    The command restores all the control files.

    C

    The command fails because the database is running.

    D

    This is the correct way to address this problem.

    E

    This is not the correct way to address this problem.


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

  • 第19题：

    多选题
    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.


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

  • 第20题：

    单选题
    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


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

  • 第21题：

    多选题
    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 duplicated

    B

    The read-only tablespaces in the target database are still defined in new the database

    C

    The read-only tablespaces in the target database are changed to online after duplication

    D

    The data files of the read-only tablespaces in the target database get duplicated

    E

    The read-only tablespaces in the target database are not defined in the new database


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

  • 第22题：

    多选题
    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
    解析： 暂无解析

  • 第23题：

    多选题
    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


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

  • 第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
    解析： 暂无解析

相关内容