|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-02-25 18:10:11), 站内信件 |
| 71. You are the administrator of 12 SQL Server 2000 computers. These servers are located in company offices throughout the world. You configure a multiserver job on the server in your company's New York City office. You configure this server as a master server, and designate the remaining 11 servers as target servers.
After the job completes successfully, you decide to set up a new SQL Server 2000 computer as the master server. The new server will be named JobMaster and the other 12 servers will be target servers. You need to make the New York City server a target server instead of a master server. What should you do? A. On the New York City server, defect all 11 target servers. On the JobMaster server, enlist the 12 servers as target servers. B. On the JobMaster server, enlist all other servers as target servers. C. On the New York City server enlist the JobMaster server as a target server. Transfer the multiserver jobs from the New York City server to the JobMaster server. D. On the JobMaster server, enlist the New York City server as a target server. On the JobMaster server, enlist the other 11 servers as target servers. On the JobMaster server, defect the New York City server. Answer: A Reason: 72. You are the administrator of 20 SQL Server 2000 computers. The servers are located in 10 company offices around the world. You work in the New York City office. You need to configure several dozen alert responses on each server. In the future, you will need to modify these alert responses periodically. You want to reduce the amount of time you spend managing alert responses. You also want to manage the alert responses from the New York City office. What should you do? A. Use SQL Enterprise Manager to manage the alert responses on all company servers. B. Configure alert forwarding on the remote servers. C. Write Transact-SQL scripts that can be used to set up alert responses on the remote servers. D. Write stored procedures that can be used to set up alert responses on the remote servers. Answer: B Reason: 网络消息传送。 73. You are the administrator of a SQL Server 2000 computer that contains a database. Users report that the database responds slowly when they insert data. You use System Monitor to examine the server’s performance and receive the results shown below: Memory Pages/sec 244. 443 PhysicalDisk _total %Disk Time 240. 198 Processor _total % Processor Time 2,000 You need to modify the server to improve its performance. What should you do? A. Install a larger hard disk. B. Increase the amount of RAM. C. Increase the size of the virtual memory paging file. D. Add an additional processor. Answer: B Reason: 内存分页太频繁了，明显内存不足的表现。 74. You are the administrator of a SQL Server 2000 computer. The server contains a database named Customers, which is used by a custom client/server application. The database contains more than 1 million rows. Users report that the database responds slowly when they search for customers by using the application. Users search for customers by scrolling through an alphabetical list of customer names. You use SQL profiles to capture information about how the application uses the database. You receive results as shown below: Event Class Text Data SQL: Batch completed Select * from customers You need to improve the application’s performance. What should you do? A. Create additional non-clustered indexes on the CustomerInformation table. B. Rewrite the application so that it uses a user-defined function to return the customer list. C. Rewrite the application so that it uses a query with a WHERE clause to search for customer names. D. Rewrite the application so that is uses a stored procedure to return the customer list. Answer: C Reason: 漫无目的的查询往往消耗大量的资源。 75. You are the administrator of a Microsoft Windows 2000 computer. The computer is also running SQL Server 2000 and contains a database named Sales. The sales department of your company uses a custom application that has just been upgraded. A user at your company named Pedro reports that when he attempts to run the weekly analysis report, he receives the following error message: “Server.Msg3704, Level 16, State 1 , Line 1 User dos not have permission to perform this operation on table ‘Report’.” You log on to Pedro’s computer, run the program, and receive no error message. You use SQL Profiler to trace database activity while you run the report. You receive the results shown below: Event Class Text Data SQL:Batch Completed Drop table report SQL:Batch Completed Drop table report (Productname C… You want to allow Pedro to run the report. You also want to minimize administrative overhead. What should you do? A. Add Pedro’s login to the db_ddladmin role in the Sales database. B. Create an application role for the sales department’s application. Grant the role database owner rights. C. Add Pedro to the db_datawriter role in the Sales database. D. Add Pedro to the local administrators group on the server. Answer: A Reason: B D所给予的权限都过高，不合适。 ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |