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

第1题：

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

• A、 MMAN
• B、 PMON
• C、 MMON
• D、 MMNL

第2题：

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）

• A、 Enable supplemental logging for the database.
• B、 Specify undo retention guarantee for the database
• C、 Create Flashback Data Archive in the tablespace where the tables are stored.
• D、 Create Flashback Data Archive and enable Flashback Data Archive for specific tables

第3题：

第4题：

The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

• A、 LOG_BUFFER
• B、 DB_CACHE_SIZE
• C、 JAVA_POOL_SIZE
• D、 LARGE_POOL_SIZE
• E、 SHARED_POOL_SIZE
• F、 STREAMS_POOL_SIZE

第5题：

Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)

• A、Flash recovery area must be defined
• B、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).

第6题：

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.

第7题：

You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions?（）

• A、Enable supplemental logging for the database.
• B、Specify undo retention guarantee for the database.
• C、Create a Flashback Data Archive in the tablespace where the tables are stored.
• D、Create a Flashback Data Archive in any suitable tablespace.
• E、Enable Flashback Data Archiving for the tables that require tracking

第8题：

第9题：

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task?（）

• A、Enable supplemental logging for the database.
• B、Specify undo retention guarantee for the database
• C、Create Flashback Data Archive in the tablespace where the tables are stored.
• D、Create Flashback Data Archive and enable Flashback Data Archive for specific tables

第10题：

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）

• A、The command produces an error because the retention period cannot be reduced
• B、All historical data older than 3 years is purged from the flashback archive FLA1
• C、All historical data is retained but the subsequent flashback data archives are maintained for only 3 years
• D、All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time