首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
40
问题
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
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
WhentheresidentsofBuenosAireswanttochangethepesostheydonottrustintothedollarstheydo,theygotoacueva,or"
"Thisisareallyexcitingtime—aneweraisstarting,"saysPeterBazalgette,thechiefcreativeofficerofEndemol,thetelev
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
DrRichardBergland,abrainresearcherattheHarvardMedicalSchool,haswrittenapapersuggestingthathumanbrainisbasica
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
美国管理学教授弗雷德里克.赫茨伯格提出的激励理论是()
A.膜龈手术B.翻瓣术C.植骨术D.引导性组织再生术E.牙种植术
A.患者血压明显升高.体检:血压200/130mmHg(26.6/16.9kPa),眼底出血渗出、视乳头水肿。实验室报告:肾功能不全B.患者气急.端坐呼吸。体检:心脏扩大,听诊可闻及第四心音奔马律。双下肢浮肿,超声心动图报告:左心室腔明显扩大C.患者平
患者女,50岁,因呼吸衰竭入院。现患者无自主呼吸,应用简易呼吸器抢救。正确的做法是
下列各项表述中,正确的有()。
我国《刑法》规定,公司解散可分为自愿解散和强制解散。以下各项中属于公司强制解散的事由是()。
A:Goodtoseeyou.Youlookmorefitandbetter.B:______.
简析“兼采列邦之良规,无违中国之礼教”的修律原则。
民族精神是一个民族在长期共同生活和社会实践中形成的,为本民族大多数成员所认同的价值取向、思维方式、道德规范、精神气质的总和。民族精神
Despiteitsmanyusefulproperties,theuseofalcoholhasproducedsomedifficultpersonalandsocialproblems.Infact,alcoho
最新回复
(
0
)