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 per

题目

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

1.User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()A. ALTER DATABASE FLASHBACK ON;B. GRANT SELECT any transaction TO scott;C. GRANT EXECUTE ON dbms_flashback TO scott;D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

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

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

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

参考答案和解析
正确答案:B,C,D
更多“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 per”相关问题

  • 第1题：

    User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? ()(Choose four.)

    A. ALTER DATABASE FLASHBACK ON;

    B. GRANT SELECT any transaction TO scott;

    C. GRANT EXECUTE ON dbms_flashback TO scott;

    D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

    E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;

    F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;


    参考答案：B, C, D, F

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    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

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

    多选题
    User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)
    A

    ALTER DATABASE FLASHBACK ON;

    B

    GRANT SELECT any transaction TO scott;

    C

    GRANT EXECUTE ON dbms_flashback TO scott;

    D

    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

    E

    ALTER TABLESPACE undots1 RETENTION GUARANTEE;

    F

    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;


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

  • 第10题：

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

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

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

  • 第13题：

    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

  • 第14题：

    User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）

    • A、ALTER DATABASE FLASHBACK ON;
    • B、GRANT SELECT any transaction TO scott;
    • C、GRANT EXECUTE ON dbms_flashback TO scott;
    • D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
    • E、ALTER TABLESPACE undots1 RETENTION GUARANTEE;
    • F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

    正确答案:B,C,D,F

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）

    • A、 ALTER DATABASE FLASHBACK ON
    • B、 GRANT SELECT any transaction TO scott
    • C、 GRANT EXECUTE ON dbms_flashback TO scott
    • D、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
    • E、 ALTER TABLESPACE undots1 RETENTION GUARANTEE
    • F、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS

    正确答案:B,C,D,F

  • 第19题：

    User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)

    • A、ALTER DATABASE FLASHBACK ON;
    • B、GRANT SELECT any transaction TO scott;
    • C、GRANT EXECUTE ON dbms_flashback TO scott;
    • D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
    • E、ALTER TABLESPACE undots1 RETENTION GUARANTEE;
    • F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

    正确答案:B,C,D,F

  • 第20题：

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

  • 第21题：

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

  • 第22题：

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

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

相关内容