单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）AIt is the time period after which the undo data becomes obsolete.BIt is the time period after which the committed undo data would be transferred to a temporarytablespace.CIt is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.DIt is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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
When tuning a network module what is the purpose of the grace period？（）A、It defines the maximum permissible time period between missed heartbeats before a failure is detectedB、It defines the time period to wait to activate the network module after starting the cluster managerC、It defines the period between detecting a missed heartbeat and initiating a network down， allowing thenetwork to stabilizeD、It defines the time period during which， after a network failure was detected， further network failures of thesame type will be ignored
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
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.
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 moreD、Set the initialization parameter UNDO_MANAGEMENT to AUTOE、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
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.
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（） A、 An upper limit on how far you can flash back the database，depending on the information in the redo logsB、 An upper limit on how far you can flash back the database，depending on the information in the undo tablespaceC、 The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough spaceD、 The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
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.
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.
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).
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.
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.
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）.
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.
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.
单选题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？ （）AUndo data is retained until the next full database backup.BNo committed undo data will be overwritten for 10 minutes.CCommitted undo data will be kept forever if not overwritten within 600 seconds.DGuarantees that requested undo information are available until the instance is shut down.
单选题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（）AThe extents in the undo tablespace retain data until the next full database backup.BThe extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.CThe extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.DThe extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
单选题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（）AThe extents in the undo tablespace retain data until the next full database backup.BThe extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.CThe extents containing committed data in the undo tablespace are not overwritten until the instance is shutdown.DThe extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten
单选题The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）Aset DB_FLASHBACK_RETENTION_TARGET=10800 Bcreate a new scheduler window for the time period of 24 hours and use the optimizer statistics Cmodify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings Dspecify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
单选题In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）AWhen the data file of the undo tablespace is autoextensibleBWhen there are more than one undo tablespaces available in the databaseCWhen the undo tablespace is of a fixed size and retention guarantee is not enabledDWhen the undo tablespace is autoextensible and retention guarantee is not enabled
单选题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？（）AThe extents in undo tablespace retain data until the next full database backup.BThe extents containing committed data in the undo tablespace are never overwritten.CThe extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.DThe extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
单选题What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）A An upper limit on how far you can flash back the database，depending on the information in the redo logsB An upper limit on how far you can flash back the database，depending on the information in the undo tablespaceC The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough spaceD The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）AIt is the time period after which the undo data becomes obsolete.BIt is the time period after which the committed undo data would be transferred to a temporarytablespace.CIt is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.DIt is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled（）AIt is the time period after which the undo data becomes obsolete.BIt is the time period after which the committed undo data would be transferred to a temporary tablespace.CIt is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.DIt is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
单选题In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）Awhen the data file of the undo tablespace is autoextensibleBwhen there are more than one undo tablespaces available in the databaseCwhen the undo tablespace is of a fixed size and retention guarantee is not enabledDwhen the undo tablespace is autoextensible and retention guarantee is not enabled
单选题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？（）AUndo data becomes obsolete after 1，000 seconds.BUndo data gets refreshed after every 1，000 seconds.CUndo data will be stored permanently after 1，000 seconds.DCommitted undo data would be retained for 1，000 seconds if free undo space is available.EUndo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.
单选题When tuning a network module what is the purpose of the grace period？（）AIt defines the maximum permissible time period between missed heartbeats before a failure is detectedBIt defines the time period to wait to activate the network module after starting the cluster managerCIt defines the period between detecting a missed heartbeat and initiating a network down， allowing thenetwork to stabilizeDIt defines the time period during which， after a network failure was detected， further network failures of thesame type will be ignored
单选题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？（）AUndo data becomes obsolete after 1，000 seconds.BUndo data gets refreshed after 1，000 seconds.CUndo data will be stored permanently after 1，000 seconds.DCommitted undo data would be retained for 1，000 seconds if free undo space is available.EUndo data will be retained in the UNDOtablespacefor 1，000 seconds， then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency.