多选题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_R

第1题：

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 flashback
• B、The expected length of the longest-running query
• C、The number of undo tablespaces in the database
• D、The size of the Flash Recovery Area for the database instance

第2题：

You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）

• A、 It would return information regarding only the last committed transaction.
• B、 It would return only the active transactions in all the undo segments in the database.
• C、 It would return only the committed transactions in all the undo segments in the database.
• D、 It would return both active and committed transactions in all the undo segments in the database.
• E、 It would return information regarding the transactions that began and were committed in the last 30 minutes.

第3题：

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 flashback
• B、the expected length of the longest-running query
• C、the number of undo tablespaces in the database
• D、the size of the Flash Recovery Area for the database instance

第4题：

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 more
• D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
• E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

第5题：

You executed the following query：  SELECT operation， undo_sql， table_name  FROM flashback_transaction_query;  Which statement is correct regarding the query output？（）

• A、It would return information regarding only the last committed transaction.
• B、It would return only the active transactions in all the undo segments in the database.
• C、It would return only the committed transactions in all the undo segments in the database. 
• D、It would return both active and committed transactions in all the undo segments in the database.
• E、It would return information regarding the transactions that began and were committed in the last 30 minutes.

第6题：

Users in your PROD database complain about the slow response of the 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 retention
• B、create more undo segments
• C、create another undo tablespace
• D、increase the size of the undo tablespace

第7题：

You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

• A、 VERSIONS_STARTSCN
• B、 VERSIONS_STARTTIME
• C、 VERSIONS_XID
• D、 VERSIONS_OPERATION

第8题：

You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

• A、Application Server Control
• B、Oracle Management Service
• C、Oracle Enterprise Manager Repository
• D、Oracle Enterprise Manager Database Control

第9题：

You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

• A、Oracle Flashback uses undo information to construct consistent data. 
• B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
• C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
• D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

第10题：

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.