多选题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?（）AEnable supple

第1题：

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.

第2题：

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

第3题：

第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 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

第6题：

Which are the prerequisites for performing flashback transactions on your database？（）

• A、 Undo retention guarantee for the database must be configured.
• B、 Supplemental log must be enabled for the primary key.
• C、 Supplemental log must be enabled.
• D、 Execute permission on the DBMS_FLASHBACK package must be granted to the user.

第7题：

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

第8题：

第9题：

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).

第10题：

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 return
• B、Create more undo segments
• C、Create another undotablespace
• D、Increase the size of the undotablespace