单项选择题
You plan to collect the Automatic Workload Repository （AWR） data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline.
What is the correct action to achieve this？（）
A. Create and populate a SQL Tuning Set from the AWR on every Monday.
B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
C. Create a repeating baseline template.
D. Insert a finding directive for future ADDM tasks.
相关考题
-
单项选择题
Whichcomponentsareneededforsuccessfulandmostefficientrecovery.（）
A. The backup RB3 and the current online redo log files
B. the backup RB2 and the archived redo log files after the log sequence number 15622
C. Backup R81 and the archived redo log hies after the log sequence number 12871
D. The backup RB3 and the archived redo log files after the log sequence number 16721 -
单项选择题
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. -
多项选择题
Whichstatementsaretrueregardingtablecompression？（）
A. It saves disk space and reduces memory usage.
B. It saves disk space but has no effect on memory usage.
C. It incurs extra CPU overhead during DML as well as direct loading operations.
D. It incurs extra CPU overhead during DML but not direct loading operations.
E. It requires uncompress operation during I/O.
