计算机网络管理员(技师)

以下不属于网络数据库SQL Server中常见的版本的是()A、SQL Server 2000企业版B、SQL Server 2000标准版C、SQL Server 2000增强版D、SQL Server 2000开发版

题目

以下不属于网络数据库SQL Server中常见的版本的是()

  • A、SQL Server 2000企业版
  • B、SQL Server 2000标准版
  • C、SQL Server 2000增强版
  • D、SQL Server 2000开发版
如果没有搜索结果,请直接 联系老师 获取答案。
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

对于大型企业来说,宜采用下列哪个SQL Server 2000版本( )。

A、企业版

B、标准版

C、开发版

D、学习版


参考答案:A

第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.


正确答案:D
解析:Explanation:ToruntheSQLServerUpgradeWizard,youmusthaveadefaultinstanceofMicrosoftSQLServer2000installedonyourcomputer.IncorrectAnswers:A:ItisnotnecessarytouninstallSQLServer7.0.JustinstallSQLServer2000asthedefaultinstance.WecannotruntheSQLServerupgradewizardunlessSQLServer2000isinstalled.B:ToruntheSQLServerUpgradeWizard,youmusthaveadefaultinstanceofMicrosoftSQLServer2000installedonyourcomputer.C:WewanttoensurethattheSQLServer6.5databasesarelistedintheSQLServer2000installationwizard.TocreateDTStransformationpackagesthatupgradeSQLServer6.5databaseestoSQLServer2000databaseswemustinstallSQLServer2000first.

第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.


正确答案:AE
解析:Explanation:
For compatibility with earlier versions of SQL Server, the Multiprotocol Net-Library continues to support its own encryption. This fits this scenario with a SQL Server 7 and a SQL Server 2000.

Note: Network libraries are used to pass network packets between the clients and the server running SQL Server 2000. The network libraries, implemented as dynamic-link libraries (DLLs), perform. the network operations required to communicate using specific interprocess communication (IPC) mechanisms.

The Multiprotocol Net-Library uses the Windows NT remote procedure call (RPC) facility and can communicate over most IPC mechanisms supported by Windows NT such as TCP/IP Sockets, NWLink IPX/SPX, and Named Pipes; allow the use of Windows Authentication over all protocols that RPC supports; support encryption for user password authentication as well as data; and can offer performance comparable to native IPC Net-Libraries for most applications.

The Multiprotocol encryption is used only for compatibility purposes with existing systems but is not supported on Windows 98. The Secure Sockets Layer (SSL) encryption that can be enabled using the Server Network Utility is a more comprehensive encryption solution. However, SSL encryption works only with instances of SQL Server 2000 running on a computer that has been assigned a certificate from a public certification authority. The computer on which the application is running must also have a root CA certificate from the same authority.

Incorrect Answers:
B: You can force protocol encryption using SSL. Here Multiprotocol encryption must be used for compatibility purposes. SSL requires a server certificate and is not support by SQL Server 7.0.

C: You can force protocol encryption using SSL. Here Multiprotocol encryption must be used for compatibility purposes. SSL requires a server certificate and is not support by SQL Server 7.0.

D: The Secure Sockets Layer (SSL) encryption that can be enabled using the Server Network Utility is a more comprehensive encryption solution than Multiprotocol encryption. However, SSL encryption works only with instances of SQL Server 2000 running on a computer that has been assigned a certificate from a public certification authority. The Multiprotocol encryption must be used for compatibility purposes.

第4题:

以下属于网络数据库SQL Server中常见的版本的是()

  • A、SQL Server 2000企业版
  • B、SQL Server 2000标准版
  • C、SQL Server 2000个人版
  • D、SQL Server 2000企业版;SQL Server 2000标准版;SQL Server 2000个人版都是

正确答案:D

第5题:

支持SQL Server 2000中的所有可用功能,可作为企业数据库服务器使用的SQL Serve2000版本是——。

A.SQL Server 2000个人版

B.SQtL Server 2000企业版

C.SQL Server 2000开发版

D.SQL Server 2000标准版


正确答案:B
解析:支持SQl.Server 2000中的所有可用功能。可作为企业数据库服务器使用的SQL.Server 2000版本是SQL Server 2000企业版。

第6题:

以下属于网络数据库SQL Server中常见的版本的是()

A.SQL Server 2000企业版

B.SQL Server 2000标准版

C.SQL Server 2000个人版

D.SQL Server 2000企业版;SQL Server 2000标准版;SQL Server 2000个人版都是


参考答案:D

第7题:

SQL Server 2000 【】 具有任何SQL Server 2000版本的最小功能。


正确答案:桌面引擎
SQL Server 2000桌面引擎是一个基于SQL Server核心技术构建的软件数据引擎。MSDE 2000具备针对单处理器和双处理器的支持特性,是企业应用程序桌面扩展的可靠存储引擎和查询处理器。

第8题:

下列哪个版本的SQL Server是完全由微软公司开发的第一个SQL Server版本( )。

A、SQL Server4.2

B、SQL Server6.0

C、SQL Server 7.0

D、SQL Server 2000


参考答案:B

第9题:

SQL Server标准版不支持的操作系统是()。

  • A、Windows 2000 Server
  • B、Windows NT Server
  • C、Windows98
  • D、Windows 2000 Advanced Server

正确答案:C

第10题:

简述SQL Server 2000中Msdb数据库的作用。


正确答案:Msdb数据库主要用于SQL server 2000存储任务计划信息、时间处理信息、备份恢复信息以及异常报告

更多相关问题