网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which tasks are run automatically as part of the Automated Maintenance Task by default?（）ASegment AdvisorBSQL Access AdvisorCOptimizer statistics gatheringDAutomatic SQL Tuning AdvisorEAutomatic Database Diagnostics Monitor” 相关考题
考题
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A. statistics recommendationsB. SQL Profile recommendationsC. Index-related recommendationsD. restructuring of SQL recommendations
考题
The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）A. statistics recommendationsB. SQL profile recommendationsC. index-related recommendationsD. restructuring of SQL recommendations
考题
Which tasks are run automatically as part of the Automated Maintenance Task by default?()
A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor
考题
Which setting enables the baselines by default in Oracle Database 11g?()
A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()
A. to prevent the creation of an excessive number of scheduler job classesB. to allow the Automated Maintenance Tasks to use system resources without any restrictionC. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
考题
Which of the following advisors is run in every maintenance window by the auto－task system?()
A. The Memory AdvisorB. The SQL Tuning AdvisorC. The Undo AdvisorD. The SQL Access Advisor
考题
Which tasks are run automatically as part of the Automated Maintenance Task by default? ()(Choose all that apply.)
A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor
考题
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）A、 statistics recommendationsB、 SQL profile recommendationsC、 index-related recommendationsD、 restructuring of SQL recommendations
考题
Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)A、Segment AdvisorB、SQL Access AdvisorC、Optimizer statistics gatheringD、Automatic SQL Tuning AdvisorE、Automatic Database Diagnostics Monitor
考题
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）A、to prevent the creation of an excessive number of scheduler job classesB、to allow the Automated Maintenance Tasks to use system resources without any restrictionC、to allow resource sharing only among the Automated Maintenance Tasks in the maintenance windowD、to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
考题
Which setting enables the baselines by default in Oracle Database 11g？（） A、 setting the STATISTICS_LEVEL parameter to TYPICALB、 adding filters to the Automatic Database Diagnostic Monitor （ADDM）C、 enabling Automated Maintenance Task using Oracle Enterprise ManagerD、 setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A、statistics recommendationsB、SQL Profile recommendationsC、Index-related recommendationsD、restructuring of SQL recommendations
考题
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?（）A、From the Advisor Central home page, select the tuning task from the Advisor Tasks section.B、From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.C、From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.D、Either B or C
考题
Which tasks are run automatically as part of the Automated Maintenance Task by default？（） A、 Segment AdvisorB、 SQL Access AdvisorC、 Optimizer statistics gatheringD、 Automatic SQL Tuning AdvisorE、 Automatic Database Diagnostics Monitor
考题
Which of the following advisors is run in every maintenance window by the auto-task system?（）A、The Memory AdvisorB、The SQL Tuning AdvisorC、The Undo AdvisorD、The SQL Access Advisor
考题
You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）A、run Segment AdvisorB、run SQL Tuning Advisor on top SQL statementsC、run the Automatic Workload Repository （AWR） reportD、run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
考题
To view the results of a manual SQL Tuning Advisor task， which steps should the DBA take？（） A、 From the Advisor Central home page，select the tuning task from the Advisor Tasks section B、 From Advisor Central，choose SQL Advisors，SQL Tuning Advisors，Manual Tuning Task ResultsC、 From Advisor Central，choose SQL Advisors，Manual SQL Tuning Advisors，Tuning Task ResultsD、 Either B or C
考题
You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）A、Internet Information ServicesB、SQL Server BrowserC、SQL Server AgentD、Microsoft Distributed Transaction Coordinator
考题
单选题Which setting enables the baselines by default in Oracle Database 11g？（）A
setting the STATISTICS_LEVEL parameter to TYPICALB
adding filters to the Automatic Database Diagnostic Monitor （ADDM）C
enabling Automated Maintenance Task using Oracle Enterprise ManagerD
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A
statistics recommendationsB
SQL Profile recommendationsC
Index-related recommendationsD
restructuring of SQL recommendations
考题
单选题The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）A
statistics recommendationsB
SQL profile recommendationsC
index-related recommendationsD
restructuring of SQL recommendations
考题
多选题Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)ASegment AdvisorBSQL Access AdvisorCOptimizer statistics gatheringDAutomatic SQL Tuning AdvisorEAutomatic Database Diagnostics Monitor
考题
单选题Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）A
Segment AdvisorB
SQL Access AdvisorC
Undo AdvisorD
SQL Tuning Advisor
考题
多选题Which two statements are true with respect to the maintenance window？（） .AA DBA can enable or disable an individual task in all maintenance windows.BA DBA cannot change the duration of the maintenance window after it is created.CIn case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.DA DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window
考题
单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）A
statistics recommendationsB
SQL Profile recommendationsC
Index-related recommendationsD
restructuring of SQL recommendations
考题
单选题The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）A
statistics recommendationsB
SQL profile recommendationsC
index-related recommendationsD
restructuring of SQL recommendations
考题
多选题You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）AInternet Information ServicesBSQL Server BrowserCSQL Server AgentDMicrosoft Distributed Transaction Coordinator
热门标签
最新试卷