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

题目内容(请给出正确答案)

单选题

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？（）

Undo data is retained until the next full database backup.

No committed undo data will be overwritten for 10 minutes.

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

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

参考答案和解析

正确答案： B

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

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

点击查看答案
第2题

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

点击查看答案
第3题

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

点击查看答案
第4题

多选题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？（）ASet the UNDO_RETENTION parameter to 900 or more.BCreate an initial undo segment in the undo tablespace.CEnable the retention guarantee for the undo tablespace.DSet the UNDO_TABLESPACE parameter to UNDO_TBS1.ESet the UNDO_MANAGEMENT initialization parameter to AUTO.

点击查看答案
第5题

单选题You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）AThe database will not start.BThe database will start but will not retain the undo data in the undo segment.CThe database will start， and the undo segment will contain the undo data for at least one hour.DThe database will start， and the undo segment will retain the undo data for at least 15 minutes.

点击查看答案
第6题

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

点击查看答案
第7题

多选题Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）Athe size of an undo blockBthe size of the redo log filesCundo blocks generated per secondDthe size of the database buffer cacheEthe value of the UNDO_RETENTION parameter

点击查看答案

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

题目内容(请给出正确答案)

参考答案和解析

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容

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