SQL Server 2000企业版
SQL Server 2000标准版
SQL Server 2000个人版
SQL Server 2000企业版;SQL Server 2000标准版;SQL Server 2000个人版都是
第1题:
A、企业版
B、标准版
C、开发版
D、学习版
第2题:
You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.
You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.
You cancel the SQL Server upgrade wizard.
You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?
A.Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.
B.Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.
C.Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.
D.Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.
第3题:
You are the administrator of SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL Server 7.O and SQL2000 is running SQL Server 2000.
The net-libraries on SQL2000 are configured as shown in the exhibit.
SQL7 is configured so that it has the named pipes, TCP/IP, NWlink, IPX/SPX and multiprotocol Net Libraries.
SQL2000 and SQL7 exchange confidential company information. You need to ensure that unauthorized users cannot access this information.
Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
A.On SQL2000, enable the multiprotocol net library.
B.On SQL2000, select the force protocol encryption check box.
C.On SQL7, select the force protocol encryption check box.
D.On SQL2000, install a secure sockets layer (SSL) encryption certificate.
E.On SQL2000 and SQL7, enable multiprotocol encryption.
第4题:
以下不属于网络数据库SQL Server中常见的版本的是()
第5题:
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.
第6题:
A.SQL Server 2000企业版
B.SQL Server 2000标准版
C.SQL Server 2000个人版
D.SQL Server 2000企业版;SQL Server 2000标准版;SQL Server 2000个人版都是
第7题:
SQL Server 2000 【】 具有任何SQL Server 2000版本的最小功能。
第8题:
A、SQL Server4.2
B、SQL Server6.0
C、SQL Server 7.0
D、SQL Server 2000
第9题:
支持SQL Server 2000中的所有可用功能,可作为企业数据库服务器使用的SQL Serve2000版本是——。
A.SQL Server 2000个人版
B.SQtL Server 2000企业版
C.SQL Server 2000开发版
D.SQL Server 2000标准版
第10题:
SQL Server标准版不支持的操作系统是()。