多选题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?（）AThe source database backup must be copied over the net for test d

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

相似考题

1.Which three tasks can be performed using a duplicate database?()A. Testing the backup and recovery proceduresB. Testing the upgrade of an Oracle database to a new releaseC. Testing the effect of an application changes on database performanceD. Continuously updating archive log files from the target database to support failover

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

3.Which three tasks can be performed using a duplicate database? ()(Choose three.)A. Testing the backup and recovery proceduresB. Testing the upgrade of an Oracle database to a new releaseC. Testing the effect of an application changes on database performanceD. Continuously updating archive log files from the target database to support failover

4.You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

更多“多选题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?（）AThe source database backup must be copied over the net for test d”相关问题

  • 第1题：

    You are managing a 24*7 database. The backup strategy for the database is to perform user－managedbackups.Identify two prerequisites to perform the backups. (Choose two.)()

    A. The database must be opened in restricted mode.

    B. The database must be configured to run in ARCHIVELOG mode.

    C. The tablespaces are required to be in backup mode before taking the backup.

    D. The tablespaces are required to be in read-only mode before taking the backup


    参考答案：B, C

  • 第2题：

    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

    • A、It must be executed from the Oracle Database 11g environment.
    • B、It must be executed only after the SYSAUX tablespace has been created.
    • C、It must be executed from the environment of the database that is being upgraded.
    • D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
    • E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

    正确答案:C

  • 第3题：

    You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

    • A、You must shut down the database instance to perform the backups.
    • B、You must configure the Flash Recovery Area （FRA） for the database.
    • C、You can perform complete database backups without closing the database.
    • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

    正确答案:C,D

  • 第4题：

    You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）

    • A、The database must be opened in restricted mode.
    • B、The database must be configured to run in ARCHIVELOG mode.
    • C、The tablespaces are required to be in backup mode before taking the backup.
    • D、The tablespaces are required to be in read-only mode before taking the backup

    正确答案:B,C

  • 第5题：

    When youre performing active database duplication，a backup of what kind is required？（）  

    • A、 A current RMAN backup-set backup is required.
    • B、 No backup is required.
    • C、 An RMAN image backup is required.
    • D、 A manual backup is required.
    • E、 A "duplicate" preparatory backup is required.

    正确答案:B

  • 第6题：

    You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）

    • A、Multiplex all database files.
    • B、Configure the Flash Recovery Area.
    • C、Configure the database instance for ARCHIVELOG mode.
    • D、Configure the FAST_START_MTTR_TARGET initialization parameter

    正确答案:C

  • 第7题：

    多选题
    You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）
    A

    You must shut down the database instance to perform the backups.

    B

    You must configure the Flash Recovery Area （FRA） for the database.

    C

    You can perform complete database backups without closing the database.

    D

    All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.


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

  • 第8题：

    单选题
    You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands：   RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK；   What are the implications of this command？（）
    A

     It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

    B

     It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

    C

     It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

    D

     It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.


    正确答案： 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题：

    单选题
    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）
    A

     It must be executed from the Oracle Database 11g environment.

    B

     It must be executed only after the SYSAUX tablespace has been created.

    C

     It must be executed from the environment of the database that is being upgraded.

    D

     It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

    E

     It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.


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

  • 第12题：

    单选题
    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）
    A

    It must be executed from the Oracle Database 11g environment.

    B

    It must be executed only after the SYSAUX tablespace has been created.

    C

    It must be executed from the environment of the database that is being upgraded.

    D

    It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

    E

    It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.


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

  • 第13题：

    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.

    正确答案:B,C,D

  • 第14题：

    You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA， a big file tablespace of size 100 TB on tape drive， but you have tapedrives of only 10 GB each.  Which method would accomplish the task quickly and efficiently？（）  

    • A、 parallel image copy backup
    • B、 backup with MAXPIECESIZE configured for the channel
    • C、 parallel backup with MAXPIECESIZE configured for the channe
    • D、 intrafile parallel backup

    正确答案:D

  • 第15题：

    You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

    • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
    • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
    • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
    • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
    • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

    正确答案:D

  • 第16题：

    Which three tasks can be performed using a duplicate database? （）(Choose three.)

    • A、Testing the backup and recovery procedures
    • B、Testing the upgrade of an Oracle database to a new release
    • C、Testing the effect of an application changes on database performance
    • D、Continuously updating archive log files from the target database to support failover

    正确答案:A,B,C

  • 第17题：

    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）

    • A、 redo log files
    • B、 password file
    • C、 control file
    • D、 change tracking file

    正确答案:D

  • 第18题：

    Which three tasks can be performed using a duplicate database？（）

    • A、 Testing the backup and recovery procedures
    • B、 Testing the upgrade of an Oracle database to a new release
    • C、 Testing the effect of an application changes on database performance
    • D、 Continuously updating archive log files from the target database to support failover

    正确答案:A,B,C

  • 第19题：

    多选题
    You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）
    A

    The database must be opened in restricted mode.

    B

    The database must be configured to run in ARCHIVELOG mode.

    C

    The tablespaces are required to be in backup mode before taking the backup.

    D

    The tablespaces are required to be in read-only mode before taking the backup


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

  • 第20题：

    多选题
    What two are the prerequisites for enabling Flashback Database?（） (Choose two)
    A

    The database must be in ARCHIVELOG mode

    B

    The database must be in MOUNT EXCLUSIVE mode

    C

    The database must be opened in RESTRICTED mode

    D

    The database instance must be started in the NOMOUNT state

    E

    The database instance must have the keep buffer pool defined


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

  • 第21题：

    单选题
    You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）
    A

    Multiplex all database files.

    B

    Configure the Flash Recovery Area.

    C

    Configure the database instance for ARCHIVELOG mode.

    D

    Configure the FAST_START_MTTR_TARGET initialization parameter


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

  • 第22题：

    单选题
    You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）
    A

     redo log files

    B

     password file

    C

     control file

    D

     change tracking file


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

  • 第23题：

    多选题
    What two are the prerequisites for enabling Flashback Database?（）
    A

    The database must be in ARCHIVELOG mode

    B

    The database must be in MOUNT EXCLUSIVE mode

    C

    The database must be opened in RESTRICTED mode

    D

    The database instance must be started in the NOMOUNT state

    E

    The database instance must have the keep buffer pool defined


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

相关内容