|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-03-05 11:22:47), 站内信件 |
| 161. You are the administrator of a new SQL Server 2000 computer. Your company has client computers that are running Microsoft Windows 2000 Professional. All client computers require access to the server.
According to company policy, passwords must be at least eight characters long and change every 30 days. You need to implement these policies and allow client computers to connect. What should you do? (Each correct answer presents part of the solution. Choose all that apply.) A. Configure Mixed Mode authentication. B. Configure Windows Authentication. C. Create a SQL Server login for each user who will access the server. D. Create a login for the Domain Users group. Answer: B D Reason: 162. You are the administrator of several SQL Server 2000 computers. You configure these servers to send e-mail messages to SQL Server operators whenever a SQL server agent job fails or encounters an error. Your company's software developers create a set of stored procedures that send query results in e-mail messages about stored procedures that have not been successful. By using a MAP1 profile named MS Exchange Settings, you verify that SQLAgentMail is correctly configured and working properly. You need to configure the servers so that the stored procedures function correctly. Which two actions should you take? A. Set the security permissions on your e-mail server to permit multiple connections to the SQL Server mailbox. B. Set the security permissions on your e-mail sever to permit connections from the MSSQLServer service account. C. Configure the MSSQLServer service to use the same service account as the SQLServerAgent service. D. Configure the SQLServerAgent service to use the same service account as the MSSQLServer service. E. Configure SQL Mail to use the MS Exchange Settings MAPI profile. F. Configure SQL Mail to use the Default Settings MAPI profile. Answer: C F Reason: 163. You are the administrator of a new Microsoft Windows 2000 server computer named HQSQL5. HQSQL5 is a member server in your company's Windows NT 4.0 domain, which is named HQMAIN. After installing SQL Server 2000 on HQSQL5, you configure the MSSQLServer service account to use the HQMAIN\sqladmin user account, which is a member of the local administrators group on HQSQL5. You can use the HQMAIN\sqladmin user account to log on the HQSQL5. However, the MSSQLServer service fails to start. You need to start the service. What should you do? A. Revoke log on interactivity rights for the HQMAIN\sqladmin user account. B. Add the HQMAIN\sqladmin user account to the HQMAIN\Domain Admins group. C. Select the Password Never Expires check box for the HQMAIN\sqladmin user account. D. Grant log on as a service rights to the HQMAIN\sqladmin user account. Answer: C Reason: 164. You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database. During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly. You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer. What should you do? A. Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation. B. Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation. C. Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database. D. Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database. Answer: C Reason: RebildDM动作影响太大，而且也没有必要修改所有的数据库。 ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |