单选题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.
单选题
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 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).
Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.) A. Flash recovery area must be definedB. Undo retention guarantee must be enabled.C. Database must be running in archivelog mode.D. Automatic undo management must be enabled.E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.
Identify three key features of ASM.（）A、file stripingB、allocation unit mirroringC、automatic disk rebalancingD、automatic file size incrementE、automatic undo management
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、the retention period to support flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance
Which two statements are true regarding undo tablespaces（）A、The database can have more than one undo tablespace.B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、The retention period to support flashbackB、The expected length of the longest-running queryC、The number of undo tablespaces in the databaseD、The size of the Flash Recovery Area for the database instance
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)A、Flash recovery area must be definedB、Undo retention guarantee must be enabled.C、Database must be running in archivelog mode.D、Automatic undo management must be enabled.E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
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 are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task？（）A、 Enable Flashback Data Archive for the tables.B、 Specify undo retention guarantee for the database.C、 Enable supplemental logging for the database.D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E、 Create Flashback Data Archive on the tablespace on which the tables are stored.
For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT
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）.
多选题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
单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A You must use automatic undo management in the database.B You must configure OMF in your database.C You must configure ASM for storing the datafiles.D You must multiplex the online redo log file.
单选题You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task？（）A Enable Flashback Data Archive for the tables.B Specify undo retention guarantee for the database.C Enable supplemental logging for the database.D Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E Create Flashback Data Archive on the tablespace on which the tables are stored.
多选题Which two are the prerequisites to enable Flashback Data Archive？（）ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.
多选题Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）Athe retention period to support flashbackBthe expected length of the longest-running queryCthe number of undo tablespaces in the databaseDthe size of the Flash Recovery Area for the database instance
多选题Which two statements are true regarding undo tablespaces（）AThe database can have more than one undo tablespace.BThe UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.CUndo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.DAn undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
单选题You work as a database administrator for Supportcenter.cn. 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？（）A3 hoursB6 monthsCuntil last yearDuntil last commitEuntil the point when the undotablespacewas refreshedFuntil the database is shut down and the memory erased
多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
单选题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
多选题You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？（）AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
单选题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? （）AALTER DATABASE BSET TRANSACTION CALTER ROLLBACK SEGMENT DALTER TABLE