SQL Server中ALTER DATABASE可以提供以下哪些功能选项？（）

在SQL Server2005中，以下()语句可以创建存储过程。

A.create proc

B.create trigger

C.Create View

D.create database

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.

下列连接字符实现与SQL Server数据库的连接，( )是不正确的。

A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;

B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;

C.Data Source=.\\SQLEXPRESS; Database=SchoolDB; Uid=abc; Pwd=;

D.Driver={SQL Server 2000}; Server=localhost; Database=stuDB; Uid=abc; Pwd=123;

You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.

However, the existing SQL server computers in your office are configured to use the

SQL_Latin1_General_CP1_CI_AS collation.

You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.

What should you do?

A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.

B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.

C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.

D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.

You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.

You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.

How should you configure SQL1?

A．Use the ALTER DATABASE statement to change the collation of the databases on SQL1.

B．Add SQL2 as remote server.

C．Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.

D．Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.