网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 classes
B
to allow the Automated Maintenance Tasks to use system resources without any restriction
C
to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
D
to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 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
考题
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 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
考题
You notice that the elapsed time for an important database scheduler Job is unacceptably long.The job belongs to a scheduler job class and window.Which two actions would reduce the job‘s elapsed time?（）A. Increasing the priority of the job class to which the job belongsB. Increasing the job‘s relative priority within the Job class to which it belongsC. Increasing the resource allocation for the consumer group mapped to the scheduler job‘s job class within the plan mapped to the scheduler windowD. Moving the job to an existing higher priority scheduler window with the same schedule and durationE. Increasing the value of the JOB_QUEUE_PROCESSES parameterF. Increasing the priority of the scheduler window to which the job belongs
考题
A customer's plant maintenance manager invites a solution advisor to discuss Enterprise Asset Management in general and how it might help the maintenance group work more effectively and efficiently. What should the solution advisor do in the first meeting with the plant maintenance manager?（）A、Ask the plant maintenance manager about the company's history, competition, and market value.B、Ask the plant maintenance manager about their background, education, and professional experience.C、Ask the plant maintenance manager about current systems in use, issues with the system,and key areas where the manager wants to see improvements. D、Ask the plant maintenance manager about the number of employees, union representation, and how IBM Maximo Asset Management can represent employees and their skill sets.
考题
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
考题
Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（） A、 WindowB、 ProgramC、 Job_ClassD、 Window group
考题
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 two statements are true with respect to the maintenance window？（） .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
考题
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
考题
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects. Which statement is true in this scenario（）A、The statistics collection continues until all objects are processed.B、The job is terminated and the statistics collected are restored to a time before the job started.C、This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.D、The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened
考题
Which two statements are true with respect to the maintenance window? （）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.
考题
You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）A、Increasing the priority of the job class to which the job belongsB、Increasing the job's relative priority within the Job class to which it belongsC、Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowD、Moving the job to an existing higher priority scheduler window with the same schedule and durationE、Increasing the value of the JOB_QUEUE_PROCESSES parameterF、Increasing the priority of the scheduler window to which the job belongs
考题
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects. Which statement is true in this scenario（）A、The statistics collection continues until all objects are processed.B、The job is terminated and the statistics collected are restored to a time before the job started.C、This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.D、The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）A、You should create a job which is assigned to the Database Maintenance categoryB、You should create an Alert which will run another to delete the maintenance job.C、You should create a job. You schedule the job to run only once.D、You should create a job. The job uses the Automatically delete job option
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）A、For the SQL Server Agent, you should enable a fail-safe operator B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.
考题
多选题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 job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects. Which statement is true in this scenario（）A
The statistics collection continues until all objects are processed.B
The job is terminated and the statistics collected are restored to a time before the job started.C
This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.D
The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.
考题
多选题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
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）A
You should create a job which is assigned to the Database Maintenance categoryB
You should create an Alert which will run another to delete the maintenance job.C
You should create a job. You schedule the job to run only once.D
You should create a job. The job uses the Automatically delete job option
考题
单选题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
考题
单选题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
考题
单选题The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects. Which statement is true in this scenario（）A
The statistics collection continues until all objects are processed.B
The job is terminated and the statistics collected are restored to a time before the job started.C
This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.D
The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened
考题
多选题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
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）A
For the SQL Server Agent, you should enable a fail-safe operator B
You should modify the database maintenance plan, making it send an e-mail to the appropriate operators C
You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. D
You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.
考题
多选题You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）AIncreasing the priority of the job class to which the job belongsBIncreasing the job's relative priority within the Job class to which it belongsCIncreasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowDMoving the job to an existing higher priority scheduler window with the same schedule and durationEIncreasing the value of the JOB_QUEUE_PROCESSES parameterFIncreasing the priority of the scheduler window to which the job belongs
考题
单选题Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）A
WindowB
ProgramC
Job_ClassD
Window group
考题
单选题A customer's plant maintenance manager invites a solution advisor to discuss Enterprise Asset Management in general and how it might help the maintenance group work more effectively and efficiently. What should the solution advisor do in the first meeting with the plant maintenance manager?（）A
Ask the plant maintenance manager about the company's history, competition, and market value.B
Ask the plant maintenance manager about their background, education, and professional experience.C
Ask the plant maintenance manager about current systems in use, issues with the system,and key areas where the manager wants to see improvements. D
Ask the plant maintenance manager about the number of employees, union representation, and how IBM Maximo Asset Management can represent employees and their skill sets.
热门标签
最新试卷
