多选题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.（）AThe database must be opened in restricted mode.BThe database must be configured to run in AR

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

相似考题

1.What two are the prerequisites for enabling Flashback Database?()A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT EXCLUSIVE modeC. The database must be opened in RESTRICTED modeD. The database instance must be started in the NOMOUNT stateE. The database instance must have the keep buffer pool defined

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

3.What two are the prerequisites for enabling Flashback Database?() (Choose two)A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT EXCLUSIVE modeC. The database must be opened in RESTRICTED modeD. The database instance must be started in the NOMOUNT stateE. The database instance must have the keep buffer pool defined

4.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 filesB. The database must be in the MOUNT state to execute the commandC. The database must be in the NOMOUNT state to execute the commandD. The database must be opened in RESTRICTED mode before this operationE. The database must be opened with the RESETLOGS option after the flashback operation

更多“多选题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.（）AThe database must be opened in restricted mode.BThe database must be configured to run in AR”相关问题

  • 第1题：

    You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）

    • A、You must have change tracking enabled in your database
    • B、Your database must be running in NOARCHIVELOG mode
    • C、To back up a tablespace, it must be in backup mode
    • D、To back up a tablespace, it must first be taken offline

    正确答案:C

  • 第2题：

    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

    正确答案:A,B

  • 第3题：

    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

  • 第4题：

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

  • 第5题：

    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

  • 第6题：

    You are a database administrator for your company. Each night， you perform full backups of your SQL Server 2005 computer. During business hours， you perform hourly transaction log backups. You rebuild database indexes each night. You need to modify your backup strategy. You must ensure that the database recovers to a new server as quickly as possible. What should you do？（）

    • A、Schedule the full backups to run after the nightly index is rebuilt.
    • B、Schedule the full backup to run before the nightly index is rebuilt. Schedule a differential backup to run after the nightly index is rebuilt.
    • C、Schedule an additional transaction log backup to run after the nightly index is rebuilt.
    • D、Schedule a marker to be added to the transaction log before the nightly index is rebuilt.

    正确答案:A

  • 第7题：

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

  • 第8题：

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

  • 第9题：

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

    The database must be started in the MOUNT EXCLUSIVE state.

    B

    The database must have multiplexed control files.

    C

    The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.

    D

    The database must be in ARCHIVELOG mode.

    E

    The database must be in the NOMOUNT state.

    F

    The database must be opened in RESTRICTED mode.


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

  • 第10题：

    单选题
    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）
    A

    The database will open, and the tablespace automatically comes out of the backup mode.

    B

    The database will be mounted, and recovery must be performed on the USERS tablespace.

    C

    The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

    D

    The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.


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

  • 第11题：

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

  • 第12题：

    多选题
    You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）
    A

    Reregistering the target database in recovery catalog

    B

    Transporting the new tablespaces to the recovery catalog database

    C

    Syncronizing the recovery catalog with the target database control file

    D

    Performing a fresh backup of the target database to include the new data files in the catalog database


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

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

    Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）

    • A、user-managed backups.
    • B、partial database backups.
    • C、consistent database backups.
    • D、inconsistent database backups.

    正确答案:C

  • 第15题：

    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

    正确答案:A,B

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

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

  • 第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 working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）
    A

    You must have change tracking enabled in your database

    B

    Your database must be running in NOARCHIVELOG mode

    C

    To back up a tablespace, it must be in backup mode

    D

    To back up a tablespace, it must first be taken offline


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

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

  • 第24题：

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


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

相关内容