题目内容

ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? ()

A. You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance
B. You should upgrade the SQL Server 2005 application to use SQL Server 2008
C. You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance
D. You should install SQL Server 2008 as a named instance, and make the new application use the new instance.

查看答案
更多问题

如下图所示,说法正确的是()

A. 这是一个列表,它的代码中会出现第1项
B. 这是一个菜单,其代码需要包含在一对之间
C. 设计如图所示的内容可以通过快捷工具栏中的“常用-表格”来实现
D. 设计如图所示的内容可以通过快捷工具栏中的“表单”来实现

YouneedtoaddareservationforaprintdevicetoaDHCPscope.Whichtwocomponentsshouldyouincludeinthereservation?()

A. thedefaultgateway
B. theIPaddress
C. theMACaddress
D. theprinterservername
E. thesubnetmask

Which of the following events would not explain excessive CPU utilization?()

A large number of BGP sessions
B. A large BGP table
C. A router is configured with the following command: ip route 0.0.0.0 0.0.0.0 fa 0/1
D. All interface buffers are continually in use
E. A flapping interface
F. The router sends a large number of ARP requests

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of two instances both of which run on the same computer. One is a SQL Server 2008 instance; another is a SQL Server 2005 instance. There is a database named DB1 in the SQL Server 2008 instance. DB1 uses the Fulltext indexes. Several records that include the word "root" are added to DB1. An empty resultset is returned when the Fulltext index is queried for the word "root." You must make sure the query can return records that contain the word "root". What should you do?()

A. You should terminate and restart the MSFTESQL service
B. You should rebuild the full-text index
C. The word "root" should be added to the stop list
D. The word "root" should be added to the thesaurus file

答案查题题库