首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its a
You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its a
admin
2009-05-19
12
问题
You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.
A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.
You want to ensure that the journalists can query the database. What should you do?
选项
A、Create a new full-text catalog for the Articles database
B、Rebuild the full-text catalog for the Articles database
C、Create a new full-text index on the table that holds the text for the articles
D、Repopulate the full-text index on the table that holds the text for the articles
答案
D
解析
Explanation: Backing up a database does not back up full-text index data in full-text catalogs. The full-text catalog files are not recovered during a Microsoft SQL Server recovery. However, if full-text indexes have been defined for tables, the metadata for the full-text index definitions are stored in the system tables in the database containing the full-text indexes. After a database backup is restored, the full-text index catalogs can be re-created and repopulated.
Note 1:
Setting up a full-text search is a three-step procedure:
1. Make sure that the full-text indexing feature has been installed with your SQL Server.
The full-text index is installed as a service in the system. It would not have to be reinstalled after restoring a database.
2. Create a catalog in the operating system to store the full-text indexes.
A catalog can contain the indexes from one or more tables, and it is treated as a unit for maintenance purposes. In general, you shouldn’t need more than one catalog per database.
The catalog is saved outside the database on separate files
3. Before you can implement a full-text search in a given database, you must ensure that the full-text search indexes are populated regularly.
In this scenario we must recreate the index by repopulating the full-text catalog.
Note 2: A SQL Server 2000 full-text index provides support for sophisticated word searches in character string data. The full-text index stores information about significant words and their location within a given column. This information is used to quickly complete full-text queries that search for rows with particular words or combinations of words. The full-text indexes are contained in full-text catalogs. Full-text catalogs and indexes are not stored in the database to which they belong. The catalogs and indexes are managed separately by the Microsoft Search service. Backing up a database does not back up full-text index data in full-text catalogs. However, if full-text indexes have been defined for tables, the meta data is backed up when a database backup is created.
Incorrect Answers:
A: The catalog already exists. The catalog is stored outside SQL server and would not be affected by the failure and restoration of the database.
B: Rebuildning the full text catalog will not enable the Journalist to run the full-text queries. The catalogs would have to be repopulated as well.
C: The index should be repopulated since it already exists from the backup. There is no need to recreate it.
转载请注明原文地址:https://kaotiyun.com/show/fuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Climatechangeissupposedtounfoldslowly,overdecades.Butthatisnottrueupinthegreatwhitenorth,asthoseattending
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
TheUniversityNewspaperisrecruitingsomejournalists.WriteamemoonJune1,2009toallstudents,explaining1)therequirem
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Notlongago,chiefexecutiveofficers(CEOS)werelandedasheroes,leadersofthebraveneweconomy.BillGatesandJackWelchw
设置网络打印机,不允许每个连接到该计算机的用户都使用该网络打印机,只允许用户Administrators和Powerusers使用本地打印机。
随机试题
氧气瓶阀有哪几种?
小明想到一个处理废水的好办法。
男,25岁,突感上腹部剧痛。检查:血压130/80mmHg,脉搏110队/分,板样腹,肠鸣音消失。血红蛋白120g/L,血白细胞数8.0×109/L。以下提示病情危险的是
多少张床位以上的医院设护理部主任、科护士长、护士长三级负责制
城市规划纲要的主要内容是()。
温州的县级市有()。
关于Word中的项目符号和编号,以下说明不正确的是()。
放弃是一种智慧,获取是一种财富,对此你怎么看?
从社会学的眼光看,重复博弈的结果之一可能是博弈双方由陌生人变为熟人,甚至成为_________,并发展出超越当下经济互动关系之外的其他社会关系。假如当前的经济巨动关系只不过是发生在双方之间的多种社会交往之中的一种,其他社会交往就可能_________当事人
There’ssimplepremisebehindwhatLarryMyersdoesforaliving:Ifyoucansmellit,youcanfindit.Myersisthefounderof
最新回复
(
0
)