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 Reco

题目

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.
相似考题

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

2. Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

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

4.You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?()A. The database must have multiplexed redo logs for the flashback to succeed.B. The database must be MOUNTED for the flashback to succeed.C. The database must use block change tracking for the flashback to succeed.D. The database must be opened in restricted mode for the flashback to succeed.E. The database must be opened with the RESETLOGS option after the flashback is complete.F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

更多“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 Recov”相关问题

  • 第1题：

    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

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

    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

  • 第4题：

    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,D

  • 第5题：

    You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）

    • A、The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
    • B、The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
    • C、The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
    • D、The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

    正确答案: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 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.


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

  • 第9题：

    单选题
    You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）
    A

    You must have started the database instance in restricted mode.

    B

    You must have started the database instance inNORMALmode.

    C

    You must have started the database instance with server parameter file.

    D

    You must have started the database instance but must not have mounted.

    E

    You must have started the database instance but must not have opened.


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

  • 第10题：

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

  • 第11题：

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

  • 第12题：

    多选题
    You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
    A

    Flashback logs are not archived.

    B

    Flashback logs are maintained in redo log files.

    C

    Flashback logs are maintained in the Flash Recovery Area.

    D

    Flashback logs are used to maintain Flashback Database related errors.

    E

    Flashback logs need to be cleared manually after you disable Flashback Database.


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

  • 第13题：

    You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

    • A、You must have started the database instance in restricted mode.
    • B、You must have started the database instance inNORMALmode.
    • C、You must have started the database instance with server parameter file.
    • D、You must have started the database instance but must not have mounted.
    • E、You must have started the database instance but must not have opened.

    正确答案:C

  • 第14题：

    Which two statements are true regarding the database in ARCHIVELOG mode？（）

    • A、You have to shut down the database to perform the backups.
    • B、Archiving information is written to the data files and redo log files.
    • C、You can perform complete database backups without closing the database.
    • D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
    • E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

    正确答案:C,E

  • 第15题：

    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

  • 第16题：

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

    • 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

  • 第17题：

    You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

    • A、 You must ensure that the SALES database is mounted or open.
    • B、 You must restore a backup control file to perform a block media recovery.
    • C、 You must take the tools01.dbf data file offline before you start a block media recovery.
    • D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.
    • E、 You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

    正确答案:A,E

  • 第18题：

    You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point 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

  • 第19题：

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

  • 第20题：

    单选题
    You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point 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
    解析： 暂无解析

  • 第21题：

    多选题
    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）
    A

    The instance aborts.

    B

    The database cannot be recovered.

    C

    The database can be recovered by restoring the control files from the backup.

    D

    The database remains opened and you have to shut it down with the ABORT option.

    E

    The database can be restored till the point of the last closed whole database backup.


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

  • 第22题：

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

  • 第23题：

    多选题
    You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.（）
    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


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

相关内容