第1题:
第2题:
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? ()
第3题:
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 2002 instance. You upgrade this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a file named Orderdata on a remote network share. A job accesses this Orderdata file by using a CMDExec step. The job step fails to complete execution after the upgrade. You must make sure that the job can complete execution, so you have to configure the job step. What action should you perform? ()
第4题:
第5题:
第6题:
第7题:
第8题:
You should create a job which is assigned to the Database Maintenance category
You should create an Alert which will run another to delete the maintenance job.
You should create a job. You schedule the job to run only once.
You should create a job. The job uses the Automatically delete job option
第9题:
第10题:
第11题:
第12题:
第13题:
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. A new SQL Agent job has been created by you. The job includes a Windows PowerShell job step which transfer data between servers by using the SQLCmd utility. If the job fails, you must make sure that an operator named ReactGroup is informed by receiving an e-mail. So what action should you perform to achieve this goal? ()
第14题:
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. A SQL Server Agent job is failing. You find that the job history information is incomplete and seems to be truncated after you review it. All information produced by a job must be available for viewing. So what action should you perform to achieve this goal? ()
第15题:
第16题:
第17题:
第18题:
第19题:
第20题:
第21题:
第22题:
第23题:
第24题: