Shared Flashcard Set

Details

Chapter 5 Flashcards
study for the 70-432 exam
11
Computer Science
Professional
07/26/2010

Additional Computer Science Flashcards

 


 

Cards

Term
What must be done before you can create a full-text index?
Definition
You must first create a full text catalog that is mapped to a filegroup to contain one or more full text indexes.
Term
What column types can full text indexes be built upon?
Definition
  • char
  • varchar
  • nchar
  • nvarchar
  • text
  • ntext
  • image
  • xml
  • varbinary
  • varbinary(max)

*

Term
What do you need to specify to create a full text index on documents stored within a FILESTREAM?
Definition
the documents are stored in a VARBINARY(MAX) column with the FILESTREAM property enabled; to create the full text index, a type column (that designates what type of doc is stored in the VARBINARY(MAX) column) must be specified in order for the word breaker to load the appropriate filter to parse it.
Term
What is a word breaker?
Definition
word breakers are assemblies that locate breaks between words to build a list of words to be indexed.
Term
What is a stemmer?
Definition
a service that conjugates verbs so that your queries can locate information even across multiple verb tenses.
Term
Where are the contents of a full text catalog maintained?
Definition
In a filegroup in the database. Prior to SQL Server 2008, the entire contents of the catalog were maintained in a directory structure on the operating system.
Term
Which catalog option allows you to configure whether the full text engine considers accent marks when building or querying a full text index?
Definition
ACCENT_SENSITIVITY
Term
Why is the population of a full-text index not an immediate process like it is with a relational index?
Definition
because the data has to be submitted to the indexing engine, which then applies word breakers, stemmers, language files, and stop lists before merging the changes into the index.
Term
Which full text index option determines how SQL Server maintains the index when the underlying data changes, and what do the settings mean?
Definition

CHANGE_TRACKING.

Manual/Auto: SQL Server maintains a list of changes to the indexed data.

Manual: you are responsible for periodically propagating the changes into the full text index.

Auto: SQL Server automatically updates the full text index as the data is modified.

Term
What are stop words?
Definition
The list of common words that you would not normally search text upon. Includes such words as the, and, and a in the English language.
Supporting users have an ad free experience!