2. 计算机
  3. You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000

You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000

admin2009-05-19  27
问题 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 TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.
答案C
解析 Explanation: The collation of a database can be specified in the COLLATE clause of the ALTER DATABASE statement. This will change the default collation of the database that was specified when the database was created, or to alter the collation for a database where the collation was not specified when the database was created and thus the default collation of the server was used.

Incorrect Answers:
A: The collation of a database can be altered using the COLLATE clause of the ALTER DATABASE statement. It is therefore not necessary to reinstall the instance of SQL Server 2000 or to rerun the setup program. Furthermore, rerunning the SQL Server 2000 setup program would disrupt the performance of the SQL Server computer.

B: The rebuildm utility alters the master database and can be used to change the collation settings for an instance of SQL Server 2000. However, it is only the Financial database that needs to be altered as it is financial application is the only application that uses the SQL_Latin1_General_CP437_BIN collation.

D: The COLLATE clause can be specified at different levels. It can be specified for the database, a table, a column or an expression. In this scenario the collation can be altered at the database level as this will reduce administrative effort when new tables are added to the database.
转载请注明原文地址:https://jikaoti.com/ti/NwO7FFFM
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)