单选题Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee：  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this 

题目
单选题
Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee：  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this statement have on the database？（）
A

The extents in undo tablespace retain data until the next full database backup.

B

The extents containing committed data in the undo tablespace are never overwritten.

C

The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.

D

The extents containing committed data in the undo tablespace are not overwritten until the instance  is shut down.

相似考题

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.You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）A、guarantee undo retentionB、add one more redo log groupC、size the redo log files appropriatelyD、size the UNDO tablespace appropriatelyE、size the SYSTEM tablespace appropriatelyF、configure an appropriate undo retention intervalG、change automatic undo management to manual

3.In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A、when the data file of the undo tablespace is autoextensibleB、when there are more than one undo tablespaces available in the databaseC、when the undo tablespace is of a fixed size and retention guarantee is not enabledD、when the undo tablespace is autoextensible and retention guarantee is not enabled

4.In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A、When the data file of the undo tablespace is autoextensibleB、When there are more than one undo tablespaces available in the databaseC、When the undo tablespace is of a fixed size and retention guarantee is not enabledD、When the undo tablespace is autoextensible and retention guarantee is not enabled

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee：  SQL ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this s”相关问题

  • 第1题：

    You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）

    • A、set SQL_TRACE=True 
    • B、set UNDO_RETENTION=14400 
    • C、set FAST_START_MTTR_TARGET=240 
    • D、set LOG_CHECKPOINT_INTERVAL=240 
    • E、set DB_FLASHBACK_RETENTION_TARGET=14400 
    • F、set the RETENTION GUARANTEE clause for the undo tablespace

    正确答案:B,E

  • 第2题：

    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

  • 第3题：

    You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

    • A、Set the UNDO_RETENTION parameter to AUTO.
    • B、Create an initial undo segment in undotablespace.
    • C、Set the UNDO_RETENTION parameter to 900 or more
    • D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
    • E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

    正确答案:D,E

  • 第4题：

    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

  • 第5题：

    You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）

    • A、Set the UNDO_RETENTION parameter to 900 or more.
    • B、Create an initial undo segment in the undo tablespace.
    • C、Enable the retention guarantee for the undo tablespace.
    • D、Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
    • E、Set the UNDO_MANAGEMENT initialization parameter to AUTO.

    正确答案:D,E

  • 第6题：

    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

  • 第7题：

    单选题
    AUM has been retaining about 15 minutes worth of undo. You want to double the retentionperiod， but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However， AUM still retains only about 15 minutes worth of undo.  What is the problem？ （）
    A

     You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.

    B

     You need to increase the size of the undo tablespace.

    C

     The undo tablespace is not set to auto-extend.

    D

     You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.


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

  • 第8题：

    单选题
    Your database instance is configured with automatic undo management and the UNDO_RETENTIONparameter is set to 900 seconds. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this command have onthe database（）
    A

    The extents in the undo tablespace retain data until the next full database backup.

    B

    The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.

    C

    The extents containing committed data in the undo tablespace are not overwritten until the instance is shutdown.

    D

    The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten


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

  • 第9题：

    多选题
    You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）
    A

    set SQL_TRACE=True

    B

    set UNDO_RETENTION=14400

    C

    set FAST_START_MTTR_TARGET=240

    D

    set LOG_CHECKPOINT_INTERVAL=240

    E

    set DB_FLASHBACK_RETENTION_TARGET=14400

    F

    set the RETENTION GUARANTEE clause for the undo tablespace


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

  • 第10题：

    单选题
    Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee：  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this statement have on the database？（）
    A

    The extents in undo tablespace retain data until the next full database backup.

    B

    The extents containing committed data in the undo tablespace are never overwritten.

    C

    The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.

    D

    The extents containing committed data in the undo tablespace are not overwritten until the instance  is shut down.


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

  • 第11题：

    单选题
    In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
    A

    when the data file of the undo tablespace is autoextensible

    B

    when there are more than one undo tablespaces available in the database

    C

    when the undo tablespace is of a fixed size and retention guarantee is not enabled

    D

    when the undo tablespace is autoextensible and retention guarantee is not enabled


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

  • 第12题：

    单选题
    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


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

  • 第13题：

    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

  • 第14题：

    In your database， UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true？ （）

    • A、Undo data is retained until the next full database backup.
    • B、No committed undo data will be overwritten for 10 minutes.
    • C、Committed undo data will be kept forever if not overwritten within 600 seconds.
    • D、Guarantees that requested undo information are available until the instance is shut down.

    正确答案:B

  • 第15题：

    Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee：  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this statement have on the database？（）

    • A、The extents in undo tablespace retain data until the next full database backup.
    • B、The extents containing committed data in the undo tablespace are never overwritten.
    • C、The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
    • D、The extents containing committed data in the undo tablespace are not overwritten until the instance  is shut down.

    正确答案:C

  • 第16题：

    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

  • 第17题：

    Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）

    • A、The extents in the undo tablespace retain data until the next full database backup.
    • B、The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.
    • C、The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
    • D、The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.

    正确答案:B

  • 第18题：

    单选题
    In your database， UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true？ （）
    A

    Undo data is retained until the next full database backup.

    B

    No committed undo data will be overwritten for 10 minutes.

    C

    Committed undo data will be kept forever if not overwritten within 600 seconds.

    D

    Guarantees that requested undo information are available until the instance is shut down.


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

  • 第19题：

    单选题
    Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）
    A

    The extents in the undo tablespace retain data until the next full database backup.

    B

    The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.

    C

    The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.

    D

    The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.


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

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

    单选题
    In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
    A

    When the data file of the undo tablespace is autoextensible

    B

    When there are more than one undo tablespaces available in the database

    C

    When the undo tablespace is of a fixed size and retention guarantee is not enabled

    D

    When the undo tablespace is autoextensible and retention guarantee is not enabled


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

  • 第22题：

    单选题
    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


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

  • 第23题：

    多选题
    You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）
    A

    Set the UNDO_RETENTION parameter to 900 or more.

    B

    Create an initial undo segment in the undo tablespace.

    C

    Enable the retention guarantee for the undo tablespace.

    D

    Set the UNDO_TABLESPACE parameter to UNDO_TBS1.

    E

    Set the UNDO_MANAGEMENT initialization parameter to AUTO.


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

  • 第24题：

    多选题
    You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）
    A

    Set the UNDO_RETENTION parameter to AUTO.

    B

    Create an initial undo segment in undotablespace.

    C

    Set the UNDO_RETENTION parameter to 900 or more

    D

    Set the initialization parameter UNDO_MANAGEMENT to AUTO

    E

    Set the UNDO_MANAGEMENT parameter to the name of an undotablespace


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

相关内容