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
A、Segment Advisor
B、SQL Access Advisor
C、Optimizer statistics gathering
D、Automatic SQL Tuning Advisor
E、Automatic Database Diagnostics Monitor
A、Segment Advisor B、SQL Access Advisor C、Optimizer statistics gathering D、Automatic SQL Tuning Advisor E、Automatic Database Diagnostics Monitor
A、In the Backup utility, clear the Enabled (scheduled tasks runs at specified time) check box. B、In Control Panel, use Scheduled Tasks to pause Task Scheduler. C、Run the Schtasks command with the /end /p parameters. D、Use the Services snap-in to change the startup type of the Task Scheduler service from Automatic to Manual.
A、 Segment Advisor B、 SQL Access Advisor C、 Optimizer statistics gathering D、 Automatic SQL Tuning Advisor E、 Automatic Database Diagnostics Monitor
A、A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema. B、B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only. C、C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state. D、D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
A、Pause the Task Scheduler service. B、Delete the scheduled backup job. Re-create the backup after you finish troubleshooting. C、Modify the properties of the scheduled backup job and clear the Enabled check box. D、Run the ntbackup /p command on the server.
A、A DBA can enable or disable an individual task in all maintenance windows. B、A DBA cannot change the duration of the maintenance window after it is created. C、In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours. D、A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.
A、 They are created automatically and stored on the FI B、 They are created manually and exported to a remote server C、 They are automatically scheduled to run every 24 hours D、 They are manually scheduled and stored on the FI
A、From Administrative Tools, run Services. B、From Administrative Tools, run File Server Manager. C、From Windows System Tools, run Scheduled Tasks. D、From Windows System Tools, run System Information.