set DB_FLASHBACK_RETENTION_TARGET=10800
create a new scheduler window for the time period of 24 hours and use the optimizer statistics
modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings
specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
第1题:
A.A
B.B
C.C
D.D
第2题:
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?()
第3题:
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
第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?()
第5题:
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()
第6题:
You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation.What should you do?()
A.A
B.B
C.C
D.D
第7题:
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?()
第8题:
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?()
A. The collection level for the AWR should be set to BASIC
B. The moving window size must be less than Undo Retention
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
第9题:
You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?()
第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?()