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

题目

单选题

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

ALTER DATABASE

SET TRANSACTION

ALTER ROLLBACK SEGMENT

ALTER TABLE

更多“单选题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 R”相关问题

第1题

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.

点击查看答案
第2题

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

点击查看答案
第3题

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.

点击查看答案
第4题

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

点击查看答案
第5题

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）A、ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C、ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D、ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

点击查看答案
第6题

单选题AUM has been retaining about 15 minutes worth of undo. You want to double the retentionperiod， but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However， AUM still retains only about 15 minutes worth of undo. What is the problem？（）AYou need to alter the undo tablespace to add the RETENTION GUARANTEE setting.BYou need to increase the size of the undo tablespace.CThe undo tablespace is not set to auto-extend.DYou need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.

点击查看答案
第7题

单选题You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）AALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；BALTER DATABASE ENABLE BLOCK CHANGE TRACKING；CALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；DALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；

点击查看答案

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

题目

更多“单选题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 R”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容