多项选择题

Which tasks are run automatically as part of the Automated Maintenance Task by default?（）

A. Segment Advisor
B. SQL Access Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor

相关考题

Examine the following set of RMAN commands: Which stat...

单项选择题

Examine the following set of RMAN commands:

Which statement is true when the RMAN RUN block Is executed?（）

A. The execution of the script fails because multiple channels cannot coexist.
B. The script is executed and both the channels are used for the script execution.
C. The new channel, CHI, is Ignored because a channel has been configured already.
D. ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.

You are using Recovery Manager (RMAN) for backup and re...

单项选择题

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.
On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task? （）

A. A
B. B
C. C
D. D

You plan to control the sessions performing a huge numb...

单项选择题You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）

A. Set a threshold for the default system-defined moving window baseline.
B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).
C. Modify the profile for the targeted users for which control needs to be imposed.
D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

OCP 11G认证考试

Which tasks are run automatically as part of the Automated Maintenance Task by default?（）