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 retentio

第1题：

You have a domain controller that runs Windows Server 2008 R2 and is configured as a DNS  server.     You need to record all inbound DNS queries to the server.     What should you configure in the DNS Manager console（）

• A、Enable debug logging.
• B、Enable automatic testing for simple queries.
• C、Enable automatic testing for recursive queries.
• D、Configure event logging to log errors and warnings.

第2题：

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.

第3题：

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

第4题：

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

第5题：

What are the prerequisites for performing flashback transactions? （）(Choose all that apply)

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

第6题：

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

第7题：

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

第8题：

You have a domain controller that runs Windows Server 2008 and is configured as a DNS server You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console（）

• A、Enable debug logging.
• B、Enable automatic testing for simple queries.
• C、Enable automatic testing for recursrve queries.
• D、Configure event logging to log errors and warnings.

第9题：

第10题：

第11题：

第12题：

第13题：

You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）

• A、guarantee undo retention
• B、add one more redo log group
• C、size the redo log files appropriately
• D、size the UNDO tablespace appropriately
• E、size the SYSTEM tablespace appropriately
• F、configure an appropriate undo retention interval
• G、change automatic undo management to manual

第14题：

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

第15题：

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

第16题：

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

第17题：

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.

第18题：

The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）

• A、set DB_FLASHBACK_RETENTION_TARGET=10800  
• B、create a new scheduler window for the time period of 24 hours and use the optimizer statistics 
• C、modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings 
• D、specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations

第19题：

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

第20题：

第21题：

第22题：

第23题：

第24题：