|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-07-23 14:08:15), 站内信件 |
| 146. You are the administrator of a SQL Server 2000 computer. The server contains a database named Orders, which is used to record customer orders for the products your company sells. Your company's order volume exceeds 1 million orders per day. Each order uses approximately 100 KB of space in the database. Users report that the database responds slowly when they enter new orders. You use SQL Profiler to monitor the activity on the database and receive the data shown below:
StartTime EventClass 2001-07-22 03:43:13 Data File Auto Grow 2001-07-22 03:43:15 Data File Auto Grow 2001-07-22 03:43:17 Data File Auto Grow 2001-07-22 03:43:19 Data File Auto Grow 2001-07-22 03:43:21 Data File Auto Grow You need to modify the database to improve performance. What should you do? A. Double the size of the data file B. Configure the database to automatically grow by 10 percent C. Separate the database into two physical files D. Increase the size of the transaction log file Answer: B Reason: 由于每次设定的数据库增量都比较小，因此不断地导致数据库自动增长，从而影响了数据库性能。原来选择了A，后来想想A也不对呀，等到新增的空间用完了，以上的情况又会出现的，所以这是治标不治本的做法，不正确。 147. You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. Users report that the database times out when they attempt to perform queries. You use System Monitor to analyze the server and receive the results shown below: SQLServer:Access Methods Full Scans/sec 0.000 SQLServer:Latches Latch Waits/sec 14.241 SQLServer:Locks _Total Lock Requests/sec 73402.577 SQLServer:SQL Statistics Batch Requests/sec 61.020 You need to discover why database performance is slow. What should you do? A. Use the current Activity window to discover who is holding locks in the database. B. Use SQL Profiler to discover who is scanning tables in the database. C. Measure disk activity by running the diskperf /y command, restarting, then using the % Disk Time counter in System Monitor. D. Use the sp_monitor stored procedure to measure the activity of the server. Answer: A Reason: 148. You are the administrator of a SQL Server 2000 computer. The server contains a database named MedicalRecords. The data processing department in your company adds new business rules to the database's stored procedures. After the rules are added, users report that the medical records application receives time-out errors. You use System Monitor to analyze the server and receive the results shown below: SQLServer:Access Methods Full Scans/sec 0.000 Index Searches/sec 5601.116 SQLServer:Cache Manager Adhoc SQL Plans Procedure Plans Cache Hit Ratio 99.810 .056 SQLServer:Locks _Total Lock Requests/sec 9700.577 SQLServer:SQL Statistics Batch Requests/sec 51.020 SQL Compilations/sec 51.020 SWL Re-Compilations/sec 0.000 You need to tune the stored procedures to improve performance. What should you do? A. Add indexes to the fields that are used in the joins. B. Remove the WITH COMPILE option from the stored procedure. C. Remove the stored procedures and alter the application so that it uses ad hoc queries to obtain data. D. Change the transaction isolation level to Repeatable Read. Answer: D Reason: 还是锁引起的问题。 149. You are the administrator of a SQL Server 2000 computer. The SQLServerAgent service on the server is configured as shown below: Service startup account: System account Mail profile: Empty Error log file name: E:\Program Files\Microsoft SQL Include execution trace messages: Unchecked Write OEM file: Unchecked Net Send Receipt: Empty You configure two SQL Server Agent jobs to perform maintenance tasks. Each job copies files from the server to a file share on a corporate file server. Both jobs fail when you attempt to execute them. You need both jobs to execute successfully. What should you do? A.Ensure that the file copy procedures are in an ActiveScripting job step B. Make a member of the serveradmin server role the owner of both jobs C. Configure the SQLServerAgent service to use a domain account D. Grant the necessary permissions in the msdb database to the job owner's SQL Server login Answer: C Reason: D看上去是很让人迷惑的，要记住系统账号是不能赋予SQL数据库权限的。 150. You are the administrator of a Microsoft Windows NT 4.0 computer that is running SQL Server 2000. The computer contains a database named Sales. The data file and transaction log for the Sales database are located on a 9.1 GB hard disk. Both files are configured for automatic file growth. The data file occupies 7 GB of disk space. You need to calculate when you will need to add additional disk space. What should you do? A. Configure System Monitor to log disk space utilization B. Configure a database maintenance job to run the DBCC CHECKALLOC statement each night and then to log the to the job history C. Configure a SQL Server Agent job to execute the sp_spaceused stored procedure each day and then to store the results of the procedure to a table in the database D. Configure a SQL Server Agent job to execute the chkdsk utility each night at midnight and then to send the results of the utility to the default operator in an e-mail message Answer: A Reason: ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |