首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
35
问题
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
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
SupposeyouphonedyourfriendMaryseveraltimesyesterdaybutshedidn’tansweryourcallatall.Writeheranemailto1
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Evenintraditionaloffices,"thelinguafrancaofcorporateAmericahasgottenmuchmoreemotionalandmuchmoreright-brained
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
若中国1998年的啤酒消费量为205亿升,2004年的啤酒消费量为291亿升,则下列说法一定正确的是()。
Doyoufindgettingupinthemorningsodifficultthatit’spainful?Thismightbecalledlaziness,butDr.Kleitmanhasanew
患儿,男,10岁,自幼发现心脏杂音,易患感冒。查体无发绀,胸骨左缘第3、4肋间收缩期粗糙的吹风样杂音及震颤。最有可能的诊断是
男性,40岁。丙肝后肝硬化7年,3个月来明显消瘦,乏力,经常出现鼻出血,腹胀进行性加重,尿少。2小时前活动后突然晕倒。考虑最可能的诊断是
成年牛滑倒后不能起立,强行站立后患后肢不能负重,比健肢缩短,抬举困难,以蹄尖拖地行走。髋关节他动运动,有时可听到捻发音。进一步确诊的最佳方法是()
以下不适用“营改增”过渡期免税政策的是()。
公司为了实现增加资本的目的,可以将公积金的一部分转为资本。对用任意公积金转增资本的,法律没有限制,但用法定公积金转增资本时,《公司法》规定,转增后所留存的该项公积金不得少于转增前公司注册资本的()。
关于出版物促销的说法,正确的有()。
排球扣球技术教学组织中,正确的练习顺序是()。
Forthispart,youareallowed30minutestowriteashortessayentitledOnRegionalUnbalanceinEducationalDevelopmentfollo
最新回复
(
0
)