多选题Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)AFlash recovery area must be definedBUndo retention guarantee must be enabled.CDatabase must be running in archivelog mode.DAutomatic undo management must be enabl

题目
多选题
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)
A

Flash recovery area must be defined

B

Undo retention guarantee must be enabled.

C

Database must be running in archivelog mode.

D

Automatic undo management must be enabled.

E

The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

相似考题

1.You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the databaseC. Create Flashback Data Archive in the tablespace where the tables are stored.D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables

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

3.You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? ()(Choose two)A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

4.Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)A. Flash recovery area must be definedB. Undo retention guarantee must be enabled.C. Database must be running in archivelog mode.D. Automatic undo management must be enabled.E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

更多“多选题Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)AFlash recovery area must be definedBUndo retention guarantee must be enabled.CDatabase must be running in archivelog mode.DAutomatic undo management must be enabl”相关问题

  • 第1题：

    Which two are prerequisites for performing a flashback transaction?()

    A. Flashback Database must be enabled.

    B. Undo retention guarantee for the database must be configured.

    C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

    D. Supplemental logging must be enabled.

    E. Recycle bin must be enabled for the database.

    F. Block change tracking must be enabled tor the database.


    参考答案：B, C

  • 第2题：

    Which are the prerequisites for performing flashback transactions on your database？（）

    • A、 Undo retention guarantee for the database must be configured.
    • B、 Supplemental log must be enabled for the primary key.
    • C、 Supplemental log must be enabled.
    • D、 Execute permission on the DBMS_FLASHBACK package must be granted to the user.

    正确答案:B,C,D

  • 第3题：

    You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）

    • A、 Enable supplemental logging for the database.
    • B、 Specify undo retention guarantee for the database
    • C、 Create Flashback Data Archive in the tablespace where the tables are stored.
    • D、 Create Flashback Data Archive and enable Flashback Data Archive for specific tables

    正确答案:D

  • 第4题：

    Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)

    • A、Flash recovery area must be defined
    • B、Undo retention guarantee must be enabled.
    • C、Database must be running in archivelog mode.
    • D、Automatic undo management must be enabled.
    • E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

    正确答案:D,E

  • 第5题：

    Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)

    • A、Database must be running in archivelog mode.
    • B、Automatic undo management must be enabled.
    • C、Undo retention guarantee must be enabled.
    • D、The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

    正确答案:B,D

  • 第6题：

    Which two are prerequisites for performing a flashback transaction?（）

    • A、Flashback Database must be enabled.
    • B、Undo retention guarantee for the database must be configured.
    • C、EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
    • D、Supplemental logging must be enabled.
    • E、Recycle bin must be enabled for the database.
    • F、Block change tracking must be enabled tor the database.

    正确答案:B,C

  • 第7题：

    Which of the following statements is true regarding implementing a Flashback Table recovery？  （）

    • A、 An SCN is never used to perform a Flashback Table recovery.
    • B、 If a significant number of changes have been made to the table， row movement must be enabled.
    • C、 The tablespace must be offline before performing a Flashback Table recovery.
    • D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.

    正确答案:D

  • 第8题：

    多选题
    You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)
    A

    You must configure block change tracking file

    B

    You must have first level 1 backups for RMAN to restore blocks

    C

    You must ensure that the SALES database is mounted or open

    D

    You must have full or level 0 backups for RMAN to restore blocks

    E

    You must take the tools01.dbf data file offline before you start a block media recovery


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

  • 第9题：

    多选题
    Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)
    A

    Flash recovery area must be defined

    B

    Undo retention guarantee must be enabled.

    C

    Database must be running in archivelog mode.

    D

    Automatic undo management must be enabled.

    E

    The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).


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

  • 第10题：

    多选题
    Which two are prerequisites for performing a flashback transaction?（）
    A

    Flashback Database must be enabled.

    B

    Undo retention guarantee for the database must be configured.

    C

    EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

    D

    Supplemental logging must be enabled.

    E

    Recycle bin must be enabled for the database.

    F

    Block change tracking must be enabled tor the database.


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

  • 第11题：

    多选题
    Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)
    A

    Database must be running in archivelog mode.

    B

    Automatic undo management must be enabled.

    C

    Undo retention guarantee must be enabled.

    D

    The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).


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

  • 第12题：

    多选题
    You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions?（）
    A

    Enable supplemental logging for the database.

    B

    Specify undo retention guarantee for the database.

    C

    Create a Flashback Data Archive in the tablespace where the tables are stored.

    D

    Create a Flashback Data Archive in any suitable tablespace.

    E

    Enable Flashback Data Archiving for the tables that require tracking


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

  • 第13题：

    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

  • 第14题：

    You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

    • A、You must configure block change tracking file
    • B、You must have first level 1 backups for RMAN to restore blocks
    • C、You must ensure that the SALES database is mounted or open
    • D、You must have full or level 0 backups for RMAN to restore blocks
    • E、You must take the tools01.dbf data file offline before you start a block media recovery

    正确答案:C,D

  • 第15题：

    You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions?（）

    • A、Enable supplemental logging for the database.
    • B、Specify undo retention guarantee for the database.
    • C、Create a Flashback Data Archive in the tablespace where the tables are stored.
    • D、Create a Flashback Data Archive in any suitable tablespace.
    • E、Enable Flashback Data Archiving for the tables that require tracking

    正确答案:D,E

  • 第16题：

    What are the prerequisites for performing flashback transactions? （）(Choose all that apply)

    • A、Supplemental log must be enabled
    • B、Supplemental log must be enabled for the primary key
    • C、Undo retention guarantee for the database must be configured
    • D、”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user

    正确答案:A,B,D

  • 第17题：

    The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal FROM emp AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) WHERE ename = 'ALLEN'; What are the minimum requirements for the statement to execute successfully? （）

    • A、ARCHIVELOG mode must be enabled
    • B、Row Movement must be enabled for the table
    • C、FLASHBACK must be set to ON for the database
    • D、The UNDO_MANAGEMENT parameter must be set to AUTO
    • E、The UNDO_RETENTION parameter must be set appropriately

    正确答案:D,E

  • 第18题：

    Which two are the prerequisites to enable Flashback Data Archive？（）

    • A、 Database must be running in archivelog mode.
    • B、 Automatic undo management must be enabled.
    • C、 Undo retention guarantee must be enabled.
    • D、 The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment  Space Management （ASSM）.

    正确答案:B,D

  • 第19题：

    单选题
    Which of the following statements is true regarding implementing a Flashback Table recovery？  （）
    A

     An SCN is never used to perform a Flashback Table recovery.

    B

     If a significant number of changes have been made to the table， row movement must be enabled.

    C

     The tablespace must be offline before performing a Flashback Table recovery.

    D

     Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.


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

    多选题
    Which are the prerequisites for performing flashback transactions on your database？（）
    A

    Undo retention guarantee for the database must be configured.

    B

    Supplemental log must be enabled for the primary key.

    C

    Supplemental log must be enabled.

    D

    Execute permission on the DBMS_FLASHBACK package must be granted to the user.


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

  • 第22题：

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

  • 第23题：

    多选题
    Which two are the prerequisites to enable Flashback Data Archive？（）
    A

    Database must be running in archivelog mode.

    B

    Automatic undo management must be enabled.

    C

    Undo retention guarantee must be enabled.

    D

    The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment  Space Management （ASSM）.


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

  • 第24题：

    多选题
    What are the prerequisites for performing flashback transactions? （）(Choose all that apply)
    A

    Supplemental log must be enabled

    B

    Supplemental log must be enabled for the primary key

    C

    Undo retention guarantee for the database must be configured

    D

    ”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user


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

相关内容