|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-03-05 11:22:47), 站内信件 |
| 151. You are the administrator of an SQL Server 2000 computer. You create a job to perform several database maintenance tasks. This job must run whenever the server is restarted. You use SQL Server Enterprise Manager to create a new schedule entry for the job, and specify that the job should start automatically. You test the job by restarting the server. You check the job's history and discover that the job did not run. You need the job to run automatically when the server restarts. What should you do?
A. Create a stored procedure that uses sp_start_job to start the job whenever the MSSQLService service starts B. Add another schedule entry to the job, specifiy that the job start hourly, and then disable the job C. Change the job's category to Database Maintenance D. Configure the SQLServerAgent service to start automatically Answer: D Reason: 152. You are the administrator of eight SQL Server 2000 computers. You configure alerts on each server so that various problem conditions will be reported if they occur. You create 18 operators on one of the servers. You configure these operators by using the e-mail and pager contact information for the employees in your department. You configure the alerts on the server to send e-mail messages and pager messages to the appropriate operators. You need to configure the same 18 operators on the other seven servers. You want to do this with a minimum amount of administrative time. What should you do? A. Detach the msdb database from the first server Copy the database to the other seven servers Attach the database on all eight servers B. Use SQL Server Enterprise Manager on a single client computer to create the operators on each server C. Use SQL Server Enterprise Manager to script all of the operators Use SQL Query Analyzer to run the script on the other seven servers D. Use snapshot replication to replicate the msdb database from the first server to the other seven servers Answer: C Reason: 153. You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. A company e-commerce application uses the Sales database to store sales transactions. The company Web site has grown in popularity, and database utilization has increased. You need to collect data about the utilization of server resources so that you can provide capacity planning. You want to automate the collection process so that information is gathered as quickly as possible. What should you do? A. Configure System Monitor to collect data and store it in a SQL Server table B. Create a SQL Server Agent job that executes the sp_statistics stored procedure daily and places the results in a text file C. Use SQL Profiler to trace server activity and store the results in SQL Server tables D. Configure SQL Server alerts to store information in the Windows application event log Answer: C Reason: 154. You are the administrator of an SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening. You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason. While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started. You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do? A. Configure SQLAgentMail to use a valid MAPI profile B. Configure SQL Mail to use a mailbox that delegates permissions to the operator C. Use the net send notification method to send the operator e-mail messages D. Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts Answer: A Reason: 155. You are the administrator of a SQL Server 2000 computer named CorpSQL. You configure several SQL Server Agent jobs to perform automated maintenance tasks on CorpSQL. The jobs execute properly for several weeks, and then stop executing. You discover that the SQLServerAgent service has stopped. You attempt to start the SQLServerAgent service. The service does not start. In the Microsoft Windows application event log you discover the following error message: "SQLServerAgent could not be started (reason: Unable to connect to server 'CORPSQL', SQLServerAgent cannot start)". You verify that the MSSQLServer service is running. You need to start the SQLServerAgent service and execute the maintenance jobs. What should you do? A. Restore the msdb database from a backup Restart the MSSQLServer service, and start the SQLServerAgent service B. Restart the server Start the MSSQLServer service, and start the SQLServerAgent service C. Configure the SQLServerAgent service to start by using the local system account D. Configure the SQLServerAgent service to start by using the same user account as the MSSQLServer service Answer: D Reason: ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |