You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?()
第1题:
Using Oracle Scheduler you have scheduled two jobs, JOB_Aand JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()
第2题:
For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.)
第3题:
The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement: SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’; What will be the outcome of this statement?()
第4题:
Which three statements are true about windows?()
第5题:
You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this? ()
第6题:
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. The instance has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration. Which Resource Governor component should you configure?()
第7题:
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? ()
第8题:
The statement will deactivate DAY_PLAN.
The statement will activate DAY_PLAN as the top plan.
The statement will activate MANAGERS_PLAN as the top plan.
The statement will return an error because MANAGERS_PLAN is not the top plan.
第9题:
Implement job classes
Implement Scheduler windows
Implement the mapping rule for the consumer groups
Set the SWITCH_TIME resource plan directive for both the resource plans
第10题:
RATIO
EMPHASIS
ACTIVE_SESS_POOL_MTH
RESOURCE_DEGREE_LIMIT_ABSOLUTE
第11题:
Mark the resource as an embedded resource in each application.
Create a resource in an XAML file that contains the logo and style configurations.
Create a resource in a custom control that contains the logo and style configurations.
Add the resource as a ResourceDictionary in the MergedDictionaries collection of each application.
Use ResourceManager to read the content of the resource. Manually assign the style configurations included in the resource file to the appropriate control in each application.
第12题:
setting idle timeout limits on resource plans
saving storage space by using compressed backup sets
creating jobs that will run automatically at a scheduled time
assigning priorities to jobs to manage access to system resources
creating alerts to perform notification when tablespaces are low on available space resources
第13题:
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?()
第14题:
For which two situations would you use functionality provided by the Resource Manager?()
第15题:
You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan?()
第16题:
You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan?()
第17题:
You create two resource plans,one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity. How would you achieve this?()
第18题:
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 management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules. What process should you implement?()
第19题:
Terminal Services application runs on the server. Users report that the application stops responding. You monitor the memory usage on the server for a week. You discover that the application has a memory leak. A patch is not currently available. You create a new resource-allocation policy in Microsoft Windows Server Resource Manager. You configure a Process Matching Criteria named TrackShip and select the application. You need to terminate the application when the application consumes more than half of the available memory on the server. What should you do?()
第20题:
You should create a cached data collection
You should create an on-demand non-cached data collection
You should create a scheduled non-cached data collection.
You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.
第21题:
Setting a metric threshold
Implementing Database Resource Manager
Enabling resumable timeout for user sessions
Decreasing the value of the IDLE_TIME resource limit in the default profile
第22题:
Window
Program
Job_Class
Window group
第23题:
A window must have been created with the WEEKEND_PLAN resource plan.
A program must have been created with the WEEKEND_PLAN resource plan.
A job class must have been created with the WEEKEND_PLAN resource plan.
A window group must have been created with the WEEKEND_PLAN resource plan.