题目内容

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

查看答案

搜索结果不匹配？点我反馈

更多问题

《医疗器械经营许可证》事项的变更分为许可事项变更和登记事项变更。许可事项变更包括（）

A. 经营场所、仓库地址
B. 经营方式、经营范围
C. 法定代表人、企业负责人
D. 住所

查看答案

您正在创建一个类，用于比较经过特殊格式设置的字符串。默认的排序规则比较不适用。您需要实现IComparable接口。您应该使用哪个代码段？（）

A
B
C
D

查看答案

点击后可插入网页的多媒体对象包括（）

A. Flash动画
B. Flash按钮
C. Flash文本
D. 插件

查看答案

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 a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer values greater than 200,000. What should you do? （）

A new partition function should be created
B. You should change the existing partition scheme
C. You should use a Merge clause to change the existing partition function
D. You should use a Split clause to change the existing partition function

查看答案

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

《医疗器械经营许可证》事项的变更分为许可事项变更和登记事项变更。许可事项变更包括（）

您正在创建一个类，用于比较经过特殊格式设置的字符串。默认的排序规则比较不适用。您需要实现IComparable接口。您应该使用哪个代码段？（）

点击后可插入网页的多媒体对象包括（）

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