单选题What is true regarding a transaction executed in Automatic Undo Management mode？（）AABBCCDD

题目
单选题
What is true regarding a transaction executed in Automatic Undo Management mode？（）
A

A

B

B

C

C

D

D

相似考题

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

2.You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.

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

4.Youhaveaproductioninstancerunningonyourserver.UNDO_RETENTIONisnotlongenoughtosatisfyread－consistencyrequirements.HowdoyouchangetheUNDO_RETENTIONvalue?()A.AB.BC.CD.D

更多“单选题What is true regarding a transaction executed in Automatic Undo Management mode？（）A AB BC CD D”相关问题

  • 第1题：

    Which two statements are true regarding undo tablespaces（）

    • A、The database can have more than one undo tablespace.
    • B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
    • C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
    • D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

    正确答案:A,C

  • 第2题：

    You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）

    • A、 It would return information regarding only the last committed transaction.
    • B、 It would return only the active transactions in all the undo segments in the database.
    • C、 It would return only the committed transactions in all the undo segments in the database.
    • D、 It would return both active and committed transactions in all the undo segments in the database.
    • E、 It would return information regarding the transactions that began and were committed in the last 30 minutes.

    正确答案:D

  • 第3题：

    SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）

    • A、The User Global Area （UGA） is not configured.
    • B、The sessions were started using the login name SYS.
    • C、The sessions are running in the Automatic Shared Memory Management mode.
    • D、The sessions are running in the automatic Program Global Area （PGA） memory management mode.

    正确答案:D

  • 第4题：

    Which two statements are true regarding transactions in an Oracle database（）

    • A、Multiple transactions can use the same undo segment.
    • B、A transaction is assigned an undo segment when it is started.
    • C、More than one transaction cannot share the same extent in the undo tablespace.
    • D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

    正确答案:A,B

  • 第5题：

    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

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

    单选题
    You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）
    A

     You must use automatic undo management in the database.

    B

     You must configure OMF in your database.

    C

     You must configure ASM for storing the datafiles.

    D

     You must multiplex the online redo log file.


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

  • 第8题：

    单选题
    Given： What is the result？（）
    A

    A

    B

    B

    C

    C

    D

    D

    E

    E


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

  • 第9题：

    多选题
    Which two statements are true regarding undo tablespaces（）
    A

    The database can have more than one undo tablespace.

    B

    The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.

    C

    Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.

    D

    An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.


    正确答案： C,B
    解析： A答案：可以有一个或多个undo表空间，A答案正确。 
    sys@TEST0924> select TABLESPACE_NAME，CONTENTS from dba_tablespaces； TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT UNDOTBS1 UNDO TEMP TEMPORARY USERS PERMANENT UNDOTBS2 UNDO 
    EXAMPLE PERMANENT LXTBS PERMANENT FLA_TBS1 PERMANENT FLA_TBS2 PERMANENT 10 rows selected. 
    B答案：UNDO_TABLESPACE只能用于自动undo段模式，B答案错误

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

    单选题
    You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）
    A

    ALTER DATABASE 

    B

    SET TRANSACTION 

    C

    ALTER ROLLBACK SEGMENT 

    D

    ALTER TABLE


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

  • 第12题：

    单选题
    You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
    A

     It would return information regarding only the last committed transaction.

    B

     It would return only the active transactions in all the undo segments in the database.

    C

     It would return only the committed transactions in all the undo segments in the database.

    D

     It would return both active and committed transactions in all the undo segments in the database.

    E

     It would return information regarding the transactions that began and were committed in the last 30 minutes.


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

  • 第13题：

    Identify three key features of ASM.（）

    • A、 file striping
    • B、 allocation unit mirroring
    • C、 automatic disk rebalancing
    • D、 automatic file size increment
    • E、 automatic undo management

    正确答案:A,B,C

  • 第14题：

    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

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

    You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）

    • A、ALTER DATABASE 
    • B、SET TRANSACTION 
    • C、ALTER ROLLBACK SEGMENT 
    • D、ALTER TABLE

    正确答案:B

  • 第18题：

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

  • 第19题：

    单选题
    SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）
    A

    The User Global Area （UGA） is not configured.

    B

    The sessions were started using the login name SYS.

    C

    The sessions are running in the Automatic Shared Memory Management mode.

    D

    The sessions are running in the automatic Program Global Area （PGA） memory management mode.


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

  • 第20题：

    多选题
    Which two statements are true regarding transactions in an Oracle database（）
    A

    Multiple transactions can use the same undo segment.

    B

    A transaction is assigned an undo segment when it is started.

    C

    More than one transaction cannot share the same extent in the undo tablespace.

    D

    The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.


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

  • 第21题：

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

    B

    add one more redo log group

    C

    size the redo log files appropriately

    D

    size the UNDO tablespace appropriately

    E

    size the SYSTEM tablespace appropriately

    F

    configure an appropriate undo retention interval

    G

    change automatic undo management to manual


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

  • 第22题：

    单选题
    You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query；  Which statement is correct regarding the query output？（）
    A

    It would return information regarding only the last committed transaction.

    B

    It would return only the active transactions in all the undo segments in the database.

    C

    It would return only the committed transactions in all the undo segments in the database.

    D

    It would return both active and committed transactions in all the undo segments in the database.

    E

    It would return information regarding the transactions that began and were committed in the last 30 minutes.


    正确答案： 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
    解析： 暂无解析

相关内容