网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
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？（） A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start， and the undo segment will contain the undo data for at least one hour.D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.
考题
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.
考题
You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）A、3 hoursB、6 monthsC、until last yearD、until last commitE、until the point when the undotablespacewas refreshedF、until the database is shut down and the memory erased
考题
You work as a database administrator for Supportcenter.cn. 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
考题
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.
考题
You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）A、Increase the undo returnB、Create more undo segmentsC、Create another undotablespaceD、Increase the size of the undotablespace
考题
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.
考题
You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.
考题
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 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.
考题
单选题You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）A
Increase the undo returnB
Create more undo segmentsC
Create another undotablespaceD
Increase the size of the undotablespace
考题
单选题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.
考题
单选题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.
考题
单选题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
考题
单选题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.
考题
单选题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 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.
考题
单选题You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）A
3 hoursB
6 monthsC
until last yearD
until last commitE
until the point when the undotablespacewas refreshedF
until the database is shut down and the memory erased
考题
单选题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？（）A
The database will not start.B
The database will start but will not retain the undo data in the undo segment.C
The database will start， and the undo segment will contain the undo data for at least one hour.D
The database will start， and the undo segment will retain the undo data for at least 15 minutes.
考题
单选题You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）A
The backup is similar to image copy.B
The backup contains all used data blocks.C
The backup contains only unused data blocks.D
The backup contains all data blocks changed since the last incremental level 1 backup.
考题
多选题You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）ASet the UNDO_RETENTION parameter to AUTO.BCreate an initial undo segment in undotablespace.CSet the UNDO_RETENTION parameter to 900 or moreDSet the initialization parameter UNDO_MANAGEMENT to AUTOESet the UNDO_MANAGEMENT parameter to the name of an undotablespace
考题
多选题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？（）ASet the UNDO_RETENTION parameter to AUTO.BCreate an initial undo segment in undotablespace.CSet the UNDO_RETENTION parameter to 900 or moreDSet the initialization parameter UNDO_MANAGEMENT to AUTOESet the UNDO_MANAGEMENT parameter to the name of an undotablespace
热门标签
最新试卷
