多选题Which two are the prerequisites to enable Flashback Data Archive？（）ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is 

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

相似考题

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.Which two client requests are captured during database replay Capture?() (Choose two)A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operations

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

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

参考答案和解析
正确答案： D,A
解析： 暂无解析
更多“Which two are the prerequisites to enable Flashback Data Arc”相关问题

  • 第1题：

    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

  • 第2题：

    Which of the following statements best describes Flashback Versions Query？（）  

    • A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
    • B、 Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.
    • C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
    • D、 Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.

    正确答案:D

  • 第3题：

    Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）

    • A、 DBWn
    • B、 RECO
    • C、 RVWR
    • D、 LGWR

    正确答案:C

  • 第4题：

    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

  • 第5题：

    You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

    • A、 Enable Flashback Data Archive for the tables.
    • B、 Specify undo retention guarantee for the database.
    • C、 Enable supplemental logging for the database.
    • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
    • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

    正确答案:A

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

  • 第8题：

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

  • 第9题：

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


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

  • 第10题：

    单选题
    Note the output of the following query；   SQL> SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table：   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE；   What is the outcome of this command？（）
    A

     The table uses the default Flashback Data Archive.

    B

     The Flashback Data Archive Is created In the SYSAUX tablespace.

    C

     The Flashback Data Archive is created in the same tablespace where the tables are stored.

    D

     The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.


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

  • 第11题：

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

  • 第12题：

    多选题
    These are the details about V$FLASHBACK_DATABASE_STAT： SQL> DESC v$FLASHBACK_DATABASE_STAT  Name                    Null？              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue？ （）
    A

    BEGIN_TIME is the time at which Flashback logging is enabled.

    B

    END_TIME is the time at which the query is executed on the view.

    C

    REDO_DATA is the number of bytes of redo data written during the interval.

    D

    This view contains information about flashback data pertaining to the last 24 hours.

    E

    FLASHBACK_DATA is the amount of flashback data generated since the database was opened.


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

  • 第13题：

    Which two client requests are captured during database replay Capture?（）

    • A、Flashback queries
    • B、Shared server requests
    • C、Login and logoff activities of sessions
    • D、Direct path load of data from external files by using utilities such as SQL *loader
    • E、Data definition language (DDL) and data manipulation language (DML) operations

    正确答案:C,E

  • 第14题：

    Which two statements regarding the Flashback Table feature are correct?（）

    • A、Flashback Table can be performed on system tables.
    • B、Flashback Table operation does not shrink the segments.
    • C、Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
    • D、Flashback Table operation acquires exclusive data manipulation language (DML) locks.

    正确答案:B,D

  • 第15题：

    You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）

    • A、 RESETLOGS
    • B、 TO TIMESTAMP
    • C、 TO BEFORE DROP
    • D、 RENAME TO
    • E、 TO SCN

    正确答案:B,E

  • 第16题：

    Which two client requests are captured during database replay Capture?（） (Choose two)

    • A、Flashback queries
    • B、Shared server requests
    • C、Login and logoff activities of sessions
    • D、Direct path load of data from external files by using utilities such as SQL *loader
    • E、Data definition language (DDL) and data manipulation language (DML) operations

    正确答案:C,E

  • 第17题：

    These are the details about V$FLASHBACK_DATABASE_STAT： SQL> DESC v$FLASHBACK_DATABASE_STAT  Name                    Null？              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue？ （）

    • A、 BEGIN_TIME is the time at which Flashback logging is enabled.
    • B、 END_TIME is the time at which the query is executed on the view.
    • C、 REDO_DATA is the number of bytes of redo data written during the interval.
    • D、 This view contains information about flashback data pertaining to the last 24 hours.
    • E、 FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

    正确答案:C,D

  • 第18题：

    Note the output of the following query；   SQL> SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table：   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE；   What is the outcome of this command？（）  

    • A、 The table uses the default Flashback Data Archive.
    • B、 The Flashback Data Archive Is created In the SYSAUX tablespace.
    • C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.
    • D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

    正确答案:A

  • 第19题：

    单选题
    You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）
    A

     Enable Flashback Data Archive for the tables.

    B

     Specify undo retention guarantee for the database.

    C

     Enable supplemental logging for the database.

    D

     Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.

    E

     Create Flashback Data Archive on the tablespace on which the tables are stored.


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

  • 第20题：

    单选题
    You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）
    A

     perform point-in-time recovery

    B

     perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

     perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

     perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery


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

  • 第21题：

    单选题
    You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）
    A

    perform point-in-time recovery

    B

    perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

    perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

    perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery


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

  • 第22题：

    多选题
    Which two aspects of a UCS solution enable fast response to growth requirements in the data  center?（）
    A

    UCS Manager

    B

    fabric interconnect

    C

    service profiles

    D

    expansion modules

    E

    virtual interface cards


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

  • 第23题：

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


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

  • 第24题：

    多选题
    You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature？ （）
    A

    RESETLOGS

    B

    TO TIMESTAMP

    C

    TO BEFORE DROP

    D

    RENAME TO

    E

    TO SCN


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

相关内容