单选题The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）A Undo data becomes obsolete after 1，000 seconds.B Undo data gets refreshed after every 1，0

题目

单选题

The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）

Undo data becomes obsolete after 1，000 seconds.

Undo data gets refreshed after every 1，000 seconds.

Undo data will be stored permanently after 1，000 seconds.

Committed undo data would be retained for 1，000 seconds if free undo space is available.

Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.

参考答案和解析

正确答案： D

解析：暂无解析

更多“单选题The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）A Undo data becomes obsolete after 1，000 seconds.B Undo data gets refreshed after every 1，0”相关问题

第1题

You work as a database administrator for Certkiller .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention is not guaranteed. Which statement regarding retention of undo data is correct？（）A、Undo data becomes obsolete after 1，000 seconds.B、Undo data gets refreshed after 1，000 seconds.C、Undo data will be stored permanently after 1，000 seconds.D、Committed undo data would be retained for 1，000 seconds if free undo space is available.E、Undo data will be retained in the UNDOtablespacefor 1，000 seconds， then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency.

点击查看答案
第2题

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）A、It is the time period after which the undo data becomes obsolete.B、It is the time period after which the committed undo data would be transferred to a temporarytablespace.C、It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.D、It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.

点击查看答案
第3题

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.

点击查看答案
第4题

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.

点击查看答案
第5题

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

点击查看答案
第6题

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled（）A、It is the time period after which the undo data becomes obsolete.B、It is the time period after which the committed undo data would be transferred to a temporary tablespace.C、It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.D、It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.

点击查看答案
第7题

The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）A、Undo data becomes obsolete after 1，000 seconds.B、Undo data gets refreshed after every 1，000 seconds.C、Undo data will be stored permanently after 1，000 seconds.D、Committed undo data would be retained for 1，000 seconds if free undo space is available.E、Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.

点击查看答案

单选题The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）A Undo data becomes obsolete after 1，000 seconds.B Undo data gets refreshed after every 1，0

题目

参考答案和解析

更多“单选题The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）A Undo data becomes obsolete after 1，000 seconds.B Undo data gets refreshed after every 1，0”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容